Forum Discussion
antonio_wurth
Helper I
2 years agoparetto 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...
- 2 years ago
Our June numbers disagree. Likely a rounding issue.
- 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.
lbendlin
Super User
2 years agoOur June numbers disagree. Likely a rounding issue.
antonio_wurth
Helper I
2 years agoi've replaced dataset with more real/full fact table
and now we are not matching(
i've uploaded on onedrive
https://1drv.ms/f/s!Asg9-7-728LO1DmJtLc7BUgYnZun?e=OMJ6Gz
can you check please?
- lbendlin2 years ago
Super User
where do you see the problem?
- antonio_wurth2 years ago
Helper I
In xlsx file I attached
With manual calculation
Numbers are different
- lbendlin2 years ago
Super User
Your new table has negative quantities. You can't really do a cumulative with these. I fudged the bucket boundaries to make it work.