Extra measures only in grand total in pivot table

[#1]

Hi Friends,

I got an urgent requirement,I have two measures Sales and Cost,But in Grand total section I want an extra column margin,but this margin will not show for the other section.I have achieved the requirement but with margin field with null values like below image

I want to remove red marked margin from the table,

any one has any idea please share with me.....

Regards

Bhawna

[Anonymous]

Hello,

Not possible on the same chart. You can achieve that with two different charts maybe.

BR

Serhan

[#3]

Hi Bhawna,

not possible like that no, one potential workaround you have is to remove the year dimension and then use extra defined expressions instead to give the totals you require.

Something like the attached, it's just an example but you can make the set analysis relative to selections made rather than set years.

hope that helps

Joe