Forum Discussion
Prior year Matrix column
Hi, I have a matrix table in my report that I want to show total sales by employee, per month and have a total sales for the previous year. I have a SQL dimension called DimEmployee, (EmpId(PK)...
updated the original post to hopefully make more sense
Hi RobbLewz
Matrix doesn't support this kind of format by default.
Would you minding adding rows to your data model or creating calculated tables?
This workaround is not dynamic.
Best Regards
Maggie