Issue with pivot chart subtotal

[sergio0592]

Hi all,

I'am facing an issue with subtotal. I have a pivot chart with  13 dimensions and 2 expressions (Z, Y). I'd like display in sub total for dimensions J and L a sum or avg. (first snaphot below)

I manage to display this only if i tick the "Show partial sum" for J and L. But the formatting pivot has changed.(see second snapshot below) .

So i want only subtotal for dimensions A and B, but display formula for dimensions J and L. Is there a way to achive this without having to put J and L in expressions.

Regards

[MindaugasBacius]

Add those field into expression as

Sum(Field1)

[sergio0592]

Yes, there is no way except put these fields as expressions as proposed by Mindaugas.

But, i have a new issue. I can't understand because for me i thought that very manageable. I want as subtotal the number of months in the chart below (and in the the attached file). I have tried with count, RowNo(),... and as a result i have 7 so, it's should be the result for : Count(TOTAL Month) and not for Count(Month) which should return 4 for Russia and 3 for UK .

[vishsaggi]

May be:

Count(Distinct Month)

[sergio0592]

Don't works, returns 4 .

[vishsaggi]

Try like

= Sum(Aggr(Count(Distinct Month), Country))

[sergio0592]

Don't works, subtotal stays at 7 .

[vishsaggi]

Can you share a sample app with the data if possible?

[sergio0592]

Qvw sample is already in attached file in one of my previous post.

[Digvijay_Singh]

May be -

Count(Total<Country> Distinct Month)