Apply different If arguments to totals

[joseph_mckeown]

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 🙂 

[Dawid]

Unfortunately not, we can’t manipulate the Totals in any way