Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this as your background color expression:
=if(Only({1} [VIGS CATEGORY]) = '3- Hospitality',rgb(102,194,150),
if(Only({1} [VIGS CATEGORY])='1- General Building Maintenance',rgb(141,170,203),
if(Only({1} [VIGS CATEGORY])='4- Office Services',rgb(255,217,47),
if(Only({1} [VIGS CATEGORY])='7- Other', rgb(252,115,98),
if(Only({1} [VIGS CATEGORY]) = '6- Food Services', rgb(187,216,84),
if(Only({1} [VIGS CATEGORY]) = '2- Pharma', rgb(231,138,210),
if(Only({1} [VIGS CATEGORY])='5- Janitorial', rgb(229,182,148),
if(Only({1} [VIGS CATEGORY]) = '8- Quotation', rgb(179,179,179)))))))))
Have you tried unchecking 'Suppress Zero Values' on the presentation tab for your pivot table?
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...
Would you be able to share a sample?
Sure, you can find it attached with this post
Check this expression:
=If(Len(Trim([VIGS CATEGORY])) > 0, If(Count(ITEMID) = 0, 0.0001, Count(ITEMID)))
=Dual(Count(ITEMID), count(TOTAL <[VIGS CATEGORY],SITE> {<YEAR=>} ITEMID))
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..
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...
Check here: