Hi everyone I want to check if it's possible to detect what level the drill down is in a table and then swap one of the measure column based on the level of drill down.
For example using superstore data, when it's Country> Region > State level, we show profit, but if Country> Region we show sales. I want to see what the if statement condition will look like for this, I assume something to do with attr() and countd() but can't shape my thoughts well around this yet.
2 answers
@Sherry Shen you could try using IF COUNTD([State]) = 1 THEN SUM([Profit]) ELSE SUM([Sales]) END
Kelsie
