Sub Totals ona pivot Table

[#1]

I need to add some sub totals for sales order quantity. sales order value etc. at customer code level.

I have ticked the show partial sums in the presentation tab but I get the above which is obviously not what I want.

Can you someone please help me out

thanks in advance

Dave

[Anil_Babu_Samineni]

Dave, Is there any chance to post the application(I mean QVW - Which you work around)

[#3]

how do I do that?

Please excuse my ignorance

[Anil_Babu_Samineni]

Uploading a Sample

[#5]

I can't do that as it's company sensitive information on other tabs

[jyothish8807]

Hi Dave,

Try using advanced aggregated expression:

sum(aggr(sum({<[LinkId] = {'SAL'},[Sales Order Status]={'Authorised'}>}[Sales Ordered Quantity]),Dim1,Dim2,Dim3...))

Regards

KC

[vcanale]

Hi,
Better to have the screenshots of Dimensions and Expressions tabs (Chart Properties)