sub-total of calculated field in Pivot table

[john9inno]

Hi,

I have some issue with getting sub-total in pivot table.

as shown in the attached, I created a report that shows sell-through proportion per marketing campaign.

there are muliple dimensions. columns in yellow look like expressions but they are actually calculated dimensions.

Calculated dimensions - Stock at the beginning, PO receipt Qty and Stock at the end

i used AGGR() to get those figures.

Now end users want sub total of those calculated fields.

requested format

is it possible to create sub total over calculated fields?

thanks so much for your input.

[Gysbert_Wassenaar]

Yes, it's possible. Please post a small qlikview document that illustrates the problem.