Totals for strait table

[Ethel]

Hello, sorry, for probably stupid question but...

I saw posts where it was discussed that I can change total calculations in the table? But how can I do it? when I open menu in measure, I see only pre-default options(Auto, AVG, Count...None). Where can I enter my formula? And second question is I have column1, column 2, column3 and measure. I want measure be averaged only by column 1 and column 2 without paying attention on column3. How can I do it?

Thanks a lot in advance!!!

[rubenmarin1 · Accepted solution]

Hi, you can use the Auto opton andin the expression use Dimesnionaly() funtion to set a differnt expression for total.

Tale total has a Dimesnionlity()=0 so, as a sample, the expression can be something like:

If(Dimensionality()=0, Avg(Value), Sum(Value))

I haven't understood your second question, can you post an image or an excel to give a sample of what you want?