Forum Discussion

antonio_wurth's avatar
2 years ago
Solved

paretto chart

hi all

need help, spent alot of time without success(

 

i have:

table fact_sales

 

column:

employee_id  (link to dim employees)

date_id (link to date dim month and year)

client_id (link to clients dim)
product_id (link to dim products)
amount

slicers: users can filter by:
a) employee_id(linkto dim employees)
b) product_id (link to dim products)(users can choose category)

i need to receive matrix like that:

 

years and months - static(last 2 years)

 

rows:

a) years
b) % - category of sales share 50% of sales, 80%, 90% 100%

columns: months

value:
distinct products


help please, thank you

13 Replies