Hide null row from pivot table

Q&A
, , ,
1

I have to show a pivot table for a field lets say Q1, attributes in rows and Wave (e.g. Q1 Q25, Q2 25 etc.) as columns and want to show counts and %s in values on Wave wise total however there are few records which are empty at Q1 and these are shown as null. Is there a way I can hide this null row without filtering out. If I filter these out it will reduce the base size thus impacting the %s.

I’m using below calculated fields since for count and %s calculations since my dataset is an unpivot one and contains duplicate responseId (i.e. record id) and I need unique count of these

count calculated filed - distinctCountOver(responseId,[Q1,Wave],PRE_AGG)

% calculated field - distinctCountOver(responseId,[Wave],PRE_AGG)

2

Hi @jitendral.yadav

Please refer to the following community post this might be helpful for you.

3

Hi @Xclipse ,

Applying filter doesn’t help since I need % as well so filtering would remove null cases from base as well impacting the %s.

4

Hi @jitendral.yadav

Use level aware calculation PRE_AGG or PRE_FILTER flags ensure calculations run before aggregation or before analysis filters, preserving correct denominators.

Please refer to the following documentations this might be helpful for you.