Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am looking for help with a formula to calculate my % mix of RO Count (Measure) within two categories of one dimension. You will see in the screen shot that I have a dimension field that sorts vehicle makes into two categories, Luxury and Non-Luxury. I am wanting to calculate % mix of RO Count for each vehicle make within it's own category, not for the overall total.
Any help is greatly apprecaited!
You can can achieve that using the TOTAL Keyword in your aggregation function
example
=sum(Sales)/Sum(TOTAL <Department> Sales)
incase of multiple dimensions
=sum(Sales)/Sum(TOTAL <Department,Store> Sales)
refer
Hello, this didn't work for me. If it helps, here is an excel example of what I am needing.
You need to add Luxury/Non-Luxury as a dimension in you load script instead of having it as a calculated dimension in the table. Then you will be able to use the suggested solution, something like this:
=count(RO)/Count(TOTAL <YourNewDimension> RO)