Associate chart problem

[#1]

Hi,

I actually have this chart

It represent the number of service request by Site.

I have 2 different chart, one pivot table and a combine bar chart.

My problem is that I have a calendar based on request date, and somes Site wasn't exist in 2014 for example so if I select 2014 my bar chart is not align with my pivot table and I dont know how to handle this.

I want to always display every Site on my pivot table like i did in my bar chart...

Ex 2014 --> PLA and SHA desappear

Thanks for your help

[sunny_talwar]

Have you tried unchecking 'Suppress Zero Values' on the presentation tab for your pivot table?

[#3]

Hi, Thanks for you answer.

I try yes, I did it on the combine chart and it works, we can see that i have not value for 2 "sites".

But if I do the same in my pivot table, no way...

[sunny_talwar]

Would you be able to share a sample?

[#5]

Sure, you can find it attached with this post

[sunny_talwar]

Check this expression:

=If(Len(Trim([VIGS CATEGORY])) > 0, If(Count(ITEMID) = 0, 0.0001, Count(ITEMID)))

[Anonymous]

=Dual(Count(ITEMID), count(TOTAL <[VIGS CATEGORY],SITE> {<YEAR=>} ITEMID))

[#8]

Hello Manuel,

Thanks for your help but it not work. Because using set analysis on year or month not allowed me to use my calendar, so I cant check my KPI for only 2014 for example. I have always the same result..

[#9]

WHat is the configuration of your check boxes on this case because if i take your expression its not better for me...
And if I open you file, its not works too...

[sunny_talwar]

Check here: