Show all months in pivot chart regardless of selections

[#1]

Hello all

Please can you advise me (a novice!) on how I can keep all the months all visible in my pivot chart below, but still make other selections dependent on selections in other sheets (as is the default)?

On the other sheets you can only select one month at a time (which is what I want) - but this chart below switches between a pivot chart and a line chart to show the differences over time, so I always want all the months showing....

Thanks

Chloe

[#2]

sorry - screen shot didn't attach...

[MK_QSL]

Consider that you have

below dimensions

Item

Year

and below expression

SUM(Sales)

....

If you want TotalSales for all Years even though particular year is selected, you need to bypass Year using set analysis in expression... like below

SUM({<Year=>}Sales)

If you have MonthYear field, you can use the same instead of Year as shown in above example.

To bypass multiple field.. use can use as

SUM({<Field1 =, Field2 =, Field3= >}Sales)

[#4]

Thanks Manish, but I am having trouble putting this into the expression i have:

IF(Dimensionality() = 0, 
IF(
'('&sum(NonCount)&')' & ' ' &
num(sum(CompCount)/(Sum(NonCount)+Sum(CompCount)),'#,##0.0%') = '(0) ', 'N/A',
num(sum(CompCount)/(Sum(NonCount)+Sum(CompCount)),'#,##0.0%'))
,

IF(
'('&sum(NonCount)&')' & ' ' &
num(sum(CompCount)/(Sum(NonCount)+Sum(CompCount)),'#,##0.0%') = '(0) ', 'N/A', '('&sum(NonCount)&')' & ' ' &
num(sum(CompCount)/(Sum(NonCount)+Sum(CompCount)),'#,##0.0%')))

my dimensions are MONTH and Compliance Category

Are you able to advise on how i insert the {MONTH=>} into the expression below? when I do it brings out incorrect data for the selection that is made?

Thanks for your help so far

Chloe

[MK_QSL · Accepted solution]

instead of

sum(NonCount)

try

sum({<Month = >}NonCount)

at every place

[#6]

Fab - thank you so much!