Notifications
Announcements
Hi Expert,
Have 2 columns in dimension which shows currently in dimension as we did not sum it but wanted to see the subtotal for the same in mdx query
i.e.
col1 col2 required column in should show same values without doing sum but should show the sumtotal and max mean
a 40 40
b 60 60
Total 100
Easiest way would be
Sum(<DataSource>,col2)
Why don't you want to use any aggregation functions?
after sum data is coming wrong...so wants to keep as it is only subtotal should work
suggestion pls
Can you show me what code you have used?
i only want subtotal , max min of the column without doing subtotal
Max(Col2)Min(Col2)
Sir, without using sum i need subtotal
Value(col2.Text)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 765 Most Valuable Professional
Michael E. Gernaey 343 Super User 2025 Season 2
Power Platform 1919 272
