Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm having a pivot table that calculates all of it expressions with SetAnalysis.
Create a weekrank and also a last-week-rank.
All expressions are working, the data is correct and if the data should show nothign a Null() is generated.
But still it show all records for the dimension. The flag Suppress when null is On.
This is a example of an expression
=IF(SUM({<[ZZSYS_COUC_YWEEK]={"$(Dash_SelWeek)"} >} [Performance Tickets])>0, SUM({<[ZZSYS_COUC_YWEEK]={"<=$(Dash_SelWeek)"} >} [Performance Tickets]), Null())
Noboddy has a clue ??
All columns are empty?
for if I can help: I usually write the expression like this >> sum (if (value> 40, sales, 0))
Do you have "show all values" on in the Dimension?
-Rob
No, is not flagged, the Suppress When value is nill is flagged