Customisation of the Totals in a chart

[santhoshkasam09]

Hi all,

I have a requirement where the totals of the chart is not usual. In a pivot table, based on the column value, the total display should change.

Is there any way to achieve this? Thank you.

Regards

Santhosh Kasam

[jmvilaplanap]

Hi,

Could you explain better your question? I don´t understand what are you trying to say.

Regards.

[jaumecf23 · Accepted solution]

You can use the Dimensionality() function. Here you have more information:

How to use - Dimensionality()

[santhoshkasam09]

Hi Jose,

For example, I am trying to display orders, backlog, etc in the pivot table which belong to one column. Under that I have to show the current year and prior year count. Now the total formula for Orders is different from the Backlog.

I want to customise the formula only for totals. Let me know in case you need anything else. Thank you

Regards

Santhosh Kasam

[santhoshkasam09]

Hi Jaume,

This worked. Thanks for your response

Regards

Santhosh Kasam