Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there, I have a pivot table with 2 dimensions: monthname(Date) as columns and Countries as rows. I also have multiple filters. What I want is no matter the filter selection, the columns (the date dimension) should remain the same (in my case from Aug 2020 - today month).
For example if I select a country or any other selection from the filters the number of columns should be the same (from Aug 2020 until today). I have different expressions which I calculate with before() and after() function and whenever the columns change my numbers get also affected.
Is there a solution for this? Either the columns should be the same or something that doesn't affect my expressions with before() and after()
Thank you
Sometimes the following trick can help:
Thank you for the answer @hic, but if I check the "Include null values" I have something like this:
I tried to remove the nulls from country and date in the loading script with len(date) > 0 and len(country) > 0 but with no success
If I uncheck "Include null values" and I add "Sum({1} 0)" I get something like below. I select country Brazil and have all the other below with null values