Pivot table total header names

[hari8088]

Hi All,

I have an issue with pivot table total headers.

Currently i have a povit table with 2 dimension and 3 expression,

I have a requirement where i should drag second dimension into vertical as shown below .

Hear the problem is Total for each year should show for particular year.For example

year 2018 total should be :2018 total

Expected output should be like below

Here are the Sample qvw and expected output files.

stalwar1‌

stevedark‌

theresaa‌

[sunny_talwar]

Unfortunately, I don't think that this would be possible

[passionate]

Hi Hari,

PFA

Cheers,

Pankaj

[sunny_talwar]

But this is showing the same year for both sub-totals... I think the OP wants this

[passionate]

yes, you are correct

[sunny_talwar]

Check to see if the attached approach works for you

[Anil_Babu_Samineni]

Only may be missed - Suppress for that Match() condition which second dim?

[hari8088]

Hi Sunny,

The approach is not working for me.In my case i have to give 3 expressions.Since i have different expressions like annual calculation for max year as well.

In pivot out put total is showing 2 times but it should not.

In case the output does not possible at least if we can get only single total.That would be helpful.

Thanks..

[hari8088]

Hi Pankaj,

Thanks for your replay.......

The condition is not working in this case.

[sunny_talwar]

Not sure what you mean?