Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For our sales team we have them setup so that a territory exists with in a region. We produce reports every week that go out to the territory manager. So the report is filtered to the territory, I want to show three metrics, the first two are easy it is the third I don't know how to do.
Structure / Roll up: Company / Region / Territory
Expressions:
1: Sales = sum(sales)
2: Sales as % of Total = sum(sales) / sum({1} sales)
3: Sales as % of Region = sum(sales) / ?
Try this:
= sum(sales) / sum({1<Territory, Region = {'$(=only(Region))'}>} sales)
Try this:
= sum(sales) / sum({1<Territory, Region = {'$(=only(Region))'}>} sales)
sum(Sales)/ sum(total <Region> aggr(sum(Sales),Region))