Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

matrix for next three year data

Hi All, I want to show in a matrix next three years' data (current, +1, +2). For example; if the slicer is selected 09.2020 then the matrix should show the data for 2020,2021 and 2022. Similarly, if...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, IF 

    Sorry, I can't solve it currently.

    Just as you can’t directly add the “BP” column to the end of the matrix, it’s also difficult for you to create a row "perc" under  "total"
    Hope someone can provide a good workaroud.

     

    Best Regards,
    Community Support Team _ Eason

  • IF's avatar
    IF
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    Hi,

    Thanks for the answer. However, I can use "relative" option only for date formated slicers, I believe. My field is text formated such as "09.2020", "09.2019", etc. "mm.yyyy". I have data for last 40 months. Therefore I can not use filter either.

    I hope there is a solution for this. 

    Regards,