How to populate sub-total and grand total in pivot table of Qlikview?

qlikview
pivot_table

#1

I am creating a pivot table to represent channel and acquisition source wise traffic, here I want to visualize this like excel pivot table, total and subtotal after each channel and acquisition source, which called in excel as sub total and grand total. Please help me to perform the similar task in QlikView.

Thanks,
Satish


#2

Satish,

You can perform this by enabling “Show partial Sum” on Presentation tab of pivot table properties. Select the dimensions, like in your case it is Channel and Acquisition Source, and enable Show Partial sum.

Regards,
Sunil