Forum Discussion
antonio_wurth
Helper I
Helper Iparetto 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...
Our June numbers disagree. Likely a rounding issue.
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_wurthHelper I
Helper Inow 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
lbendlin
Super User
Super UserPlease provide sample data that fully covers your issue.
- antonio_wurth
that the file you last send me
https://1drv.ms/u/s!Asg9-7-728LO1D8Jf6hseNtwektC?e=JAcONU
when add calendar_year to rows(before category) - chart is empty
- lbendlin
Works for me. Did you expand the rows?
- antonio_wurth
yes, now its perfect
thank you again!!!