Total Distribution Sold

[vadim_grab]

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

[swuehl]

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,

[vadim_grab]

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

[swuehl · Accepted solution]

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]) )