DJ on 27 Sep 2017 15:50:19
I have a matrix that analyses several KPIs with a multi-level drilldown, e.g. Zone, Division, Sub-Division & User.
One of the KPIs doesn't go to the bottom level of User so if all levels are shown then that measure needs to be blank on the User level.
Can I have something like Measure = IF(ROWLEVEL () = "User", BLANK () , SUM(KPIvalue))