Pivot Table Month Column Expansion Not Working When Using Calculated Dimension

[Arthur_Fong]

Hi all,

I have a problem with pivot table when expanding the month columns, it does not work.

This occurs when i attempt to apply a calculated dimension(toggle between Month and Quarter). 

The example below is what I would want to achieve:

Month selected is Jun, but Month for May and Apr is still expandable.

This works on normal Month Dimension, when i apply the calculated dimension, the problem occurs where:

Month selected is Jun, May and Apr could not be expanded.

Any idea on how to achieve the expected result?

Attached is a sample qvw with the table on 'Month\Quarter' sheet.

Thanks and regards,

Arthur Fong

[adamgaox]

Hi Jkfong,

I would suggest you implement bar chart by Drill Down group to display YTD sales value or any other KPIs.

When user notice any obvious growth or decrease they can just pick up the Month in the view to drill down to product to see where the increase coming from:

[Arthur_Fong]

Hi Adam,
This report is implemented under Financial Reporting.
User would prefer to have table reports rather than graphical charts.

Thanks.