Calculate diagonal cells in a table

[Former Member]

Hi,

I'm having trouble creating a formula for a table. I need to calculate the product (*) of cells that are diagonally.

Example;

VARIABLE = (column 1, row 1) + (column 2, row 2) + (column 3, row 3) +.......

                      column          column         column      column

        row              x                   

        row                                   x

        row                                                       x       

        row                                                                        x

Is there a funtion to calculate what I need ?

If anyone can help me,  thanks!

[former_member188911 · Accepted solution]

not sure if you can do that, if you are on BI4.0 you may wish to explore the RelativeValue() function

cheers

Simone

[Former Member · Accepted solution]

Thanks Simone!

is a crosstab, I see that it is complicated.

I'll try the RelativeValue() function,

Thanks for your answer,

Carlos.