cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tatarish Frequent Visitor
Frequent Visitor

How calculate totals ignoring the dimension?

Hello experts!
Could you tell me. How can I calculate aggregate ignoring the dimension of the matrix. In this case, you need to respond to changes in the filters.

Mediana.png

3 REPLIES 3
Community Support Team
Community Support Team

Re: How calculate totals ignoring the dimension?

Hi @tatarish,

 

Try this formula.

 

Mediana total = SUMX(ALL(table),[mediana by dim])

If it doesn't meet your requirement, kindly share your sample data to me and excepted reult to me.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: How calculate totals ignoring the dimension?

Hi @tatarish,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.

 

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: How calculate totals ignoring the dimension?

Hi @tatarish,

 

Has your issue been solved? If any other question, feel free to let me know please.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.