Hello smarter people than I,
I hope that you are well today!
Does anyone know if there is a way that I could create an IF statement with a Table Calculation that applies rules to the lines and a different rule for the totals below the raw data?
Something like,
If measure = 1, 1,
if measure = 2, 2,
if istotal(measure)=yes, 42,
0)))
let’s say.
So that a result might look like:
Row | Measure | Table Calculation |
---|---|---|
1 | 1.00 | 1 |
2 | 2.00 | 2 |
3 | 1.00 | 1 |
4 | 1.00 | 1 |
5.00 | 42 |
Any idea if this is a possibility?
Thank you! Have a nice day 🙂
Unfortunately not, we can’t manipulate the Totals in any way