Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Experts.
I'm working on task - SalesManager Dashboard.
I need any help to realize KPI -Total Distribution Sold (TDS), which present how many distinct SKU per Customer have sells manager in his territory per Month and Year .
Exapmle
Month Manager TDS = 12 000 SKU
Customers = 100
12 000 SKU / 100 = 1000 Distinct SKU per Customer
I use count(distinct SKU) to calculate individual TDS per Customer, but I have a trouble to calculate TDS per Month and Year, it must be sum all individual TDS customers.
In attached file- Excel Example
Many thanks for any help
Not sure I understand, so it would be helpful if you can post some sample data and your expected result on each aggregation level.
In general, you can add more aggr() dimensions, for example:
=Sum( Aggr( Count(DISTINCT SKU), Manager, Customer, [Year-Month]) )
Maybe try with advanced aggregation (aggr() function), something like an expression
=Sum( Aggr( Count(DISTINCT SKU), Manager, [Year-Month]) )
in a table chart with Manager and [Year-Month] dimensions,
Thanks Stephan!
It's worked, but only with two StructuredParameter AGGR()
That about more than 2 StructuredParameter for example Customer ->Manager ->Branch-> YearMonth ->Year?
Best Regards,
Vadim
Not sure I understand, so it would be helpful if you can post some sample data and your expected result on each aggregation level.
In general, you can add more aggr() dimensions, for example:
=Sum( Aggr( Count(DISTINCT SKU), Manager, Customer, [Year-Month]) )