Totals for Calculated Dimensions

[amarsaljos]

Hi Experts,

My problem is when I put a calculated dimension in a Table (in rows) and enable "Show totals", the Total row does not appear ¿What should I do to show totals?

Best regards,

[amarsaljos]

It may be related to the following Warning because de calculated dimension is based on "Componente/Resto Measure".

[saurabh_sonawane · Accepted solution]

Hi,

The calculated measure is having one mandatory dimension is set in the account dimension, so you are getting the following warning message

Please pull the "Tipo de Umbral" in the table and you will find the total in the table.

Thanks,

Saurabh S.

[amarsaljos · Accepted solution]

The point is that "Tipo Umbral" is not a dimension of my model, is an attribute that is called in the calculated measure formula.

I cannot pull it in the table as a Dimension.

[saurabh_sonawane · Accepted solution]

Hi,

Got it.

Can you pull the Epigrafe contable in the table and check.

[amarsaljos · Accepted solution]

Hi Saurabh,

The Epigrafe Contable is already on the table and doesn't work.

It is only a Componente/Reso problem. The other calculated dimensions can show Totals.

Any other solution?

Best Regards,

[saurabh_sonawane · Accepted solution]

Can you please check the account dimension?

In that check, this column and dimension are mapped or not.

Thanks,

Saurabh S.

[amarsaljos · Accepted solution]

Thanks a lot. It was related to that column of required Dimensions.

I had to change mi story calculated measure to a model one. Doing that, I've been able to fill the required dimension columns and show totals in the table.

Best Regards,