Forum Discussion

antonio_wurth's avatar
antonio_wurth
Helper I
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 c...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Your new table has negative quantities.  You can't really do a cumulative with these. I fudged the bucket boundaries to make it work.

     

     

     

     

antonio_wurth's avatar
antonio_wurth
Helper I
2 years ago

In xlsx file I attached

With manual calculation

Numbers are different

lbendlin's avatar
lbendlin
Super User
2 years ago

Your new table has negative quantities.  You can't really do a cumulative with these. I fudged the bucket boundaries to make it work.

 

 

 

 

  • antonio_wurth's avatar
    antonio_wurth
    Helper I
    2 years ago

    now number are corerct, thank you again!!!

    but i'm getting an empty matrix

    when adding year to rows

     

    also subtotals are empty as well

     

    i'm trying to buid table like that

     

    hrlp please, thank you