Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I've attached a test model with what it is I am trying to achieve. There are different comparative views that the EU can utilize to see different reporting periods. My challenge is this
I cannot get this to pivot correctly with the right periods and the right values with suppress nulls enabled. How do i get this right all
Thanks,
Byron
I've added a false value to the calculated dimension that reads 'TOTAL'. This way I represent the null as a subtotal value when populating the calendar periods. This makes things look cleaner but would still like to know if there is a way around this
Cheers,
Byron