Forum Discussion

RobbLewz's avatar
RobbLewz
Icon for Helper II rankHelper II
6 years ago

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)...
Need Help
RobbLewz's avatar
RobbLewz
Icon for Helper II rankHelper II
6 years ago

updated the original post to hopefully make more sense

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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