Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

How to display expression value only at subtotal level in pivot table.

Hi,

I have one expression field Variance%

Formula is :- Variance%= EAC-Budget / Budget.

in this image I have budget data only for Vendor C, so for that that row variance is -100%.

My requirement is how to get that variance value only at subtotal level, that is only -74% should display in report.

Pivot Table.png

11 Replies
abc_18
Creator II
Creator II
Author

Yes because I haven't selected any cost code to display subtotal value.

Only I have applied Dimensionality() formula.

rubenmarin

Hi Shikha, I will need a sample to help yo check why the table with many codes doesn't show subtotals, usual behaviour will show a subtotal for each code... Is the same table?