Replace row dimension value using set analysis

[Anonymous]

Hi! I would like to ask if there's a way to change the value of a certain row dimension in a single pivot table using conditional calculations  (Set Analysis)?

Source Table:

Desired Result:

Thanks in advance

[r_wroblewski]

Hi Jon

Yes you can use with Year, Month etc..

I think you need to add a custom value to your dimension but you can do.

I just add a 'Custom' value to Month2 dimension.

Please let me know if you have additional questions.

Regards

Ronny

[Anonymous]

Hi Lech,

Thanks for this! This resolves my issue

Regards,
Jon

[Lech_Miszkiewicz]

No worries,

regards from Down Under

cheers