Formula on Pivot Table

[#1]

Dear all,

I have a table with a lot of prices and variables.

I'm trying to do a calculated dimension with if clauses, but i have to concatenate all and it's so complicaded.

Can explain me someone if it's possible to do the next sentence:

Example

=if(A=1,1,0) + if(B=1,1,0) .......

There are a lot of combinations to do an if(A=1,if(b=1,if(c=.......), and I'm trying to do operations with separated if on the same formula.

Best regards,

[#2 · Accepted solution]

It works,