Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When you show % change in a pivot table using before function, the first column always shows a NULL which is irritating. Is there any trick to avoid it?
Hi Ram,
Try below,
Sum ([Headcount at Census])/Before(Sum ([Headcount at Census]),0)
Sorry Satyadev, it didn't work. Actually under Feb-14 i don't want %change column to appear at all. It doesn't make sense as there is no data available before that.
Hiding column in Pivot table with cross table view is really nightmare. You may have to thing some easiest way
What if you can add some text like "NA" or "Not Applicable" Or white the background Or add some text object with white background on top the column.
Try adding ALT function around your expression using above
ALT ( yourexpression, 0 )
Sorry Clever, not what i am looking for.