Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Problem: The problem I'm running into is that the pivot table hides field combinations that return no value, when you filter those dimensions. I want every month to be shown regardless if there is an associated value with that month.
For example: I've created a Master Calendar so I know every possible month-year value exists. But when i filter for Year and VaccName you can see that a value isn't returned for every month (see table2) , but more importantly most of the months aren't being shown. I would like every month (within the year selection), to be shown.
Thank you for your help!
Can you share you data in excel file?
Thanks.
Hi Ishtdeep, I already tried that but the problem is that I still want to be able to limit the data shown on the pivot table. I would like all the months to be shown but to also limit data by VaccName and Year selection.
Thanks!
I can't find the embed document function on this forum?
Click on advance editor & find the attach option at the bottom of the page.
Thanks.
You can limit the data with the help of set analysis.
Thanks.
The relevant is back-up order timing and i'm trying to fix the bottom 2 pivot tables. I tried your recommended solution in the top pivot, but i dont think its working? Thanks!
How would I go about doing that using the link you showed as well as set analysis? Any help would be greatly appreciated.
to clarify: i want to be able to show all the months of the year while filtering for vaccname and year
Please share the data in excel sheet.
Thank you!