show totals but suppress values in pivot table

[#1]

Hi

I have a pivot table as shown below. What I need is to suppress the YTD column and just show the total.

[sunny_talwar]

Would you be able to share your qvw?

[#3]

Sorry, I could not as the data is Sensitive.

It's pretty Straight forward, two dimensions Year and month

Service % is the measure calculated by the formula Supply/Demand per month

YTD is just an extension of that.

[Clever_Anjos]

I don´t think you can have 1 column at detail and 2 columns at total

[sunny_talwar]

I think we might be able to use Synthetic dimensions or Island table dimension to do this. I was just hoping to see how the data is structured to give any suggestions.

[sunny_talwar]

You can always scramble your data as mentioned here: Preparing examples for Upload - Reduction and Data Scrambling‌

Anyways, I will create a sample for you and you can check if this works for you or not

[sunny_talwar]

Have a look here:

[Clever_Anjos]

Very tricky and smart, congrats

[sunny_talwar]

Thanks Clever. I think the dimension and expressions are still not perfect because I am not seeing the accumulation, but it can be further fine-tuned to get the desired result

[sunny_talwar]

This is slightly better now