Incorrect Total in a Pivot chart

[fashid]

Hi,

I have created a pivot chart with a calculated dimension which is just a text.

I am getting wrong totals .

Is it possible to get the right total without using a straight table or will i have to use only the straight table.

I have attached the sample app

Regards,

Nadeem

[sunny_talwar]

Disregard the last response. Look at the following attachment.

Best,

Sunny

[fashid]

Hi  Sunny,

You Have disabled the entire MTD% column.

The thing is that i want the MTD % column with all the values except the total .

Is it possible to keep totals of only a particular column in the pivot chart

Regards,

Nadeem

[sunny_talwar]

All Columns are still here:

[fashid]

Perfect but how did u just get the MTD score totals .

When i enabled the partial sums i am getting totals for the rest of the columns as well

[sunny_talwar · Accepted solution]

I used a concept of Dimensionality() to turn of the totals for all others except MTD Score.

[fashid]

Many Thanks for Bearing with me and helping me solve this .

Learned a lot !!!!

Have a nice day !!

Rergards,

Nadeem

[sunny_talwar]

‌we all are learning from each other my friend.

best,

Sunny