Forum Discussion

shzyincu's avatar
shzyincu
Icon for Helper I rankHelper I
9 years ago

% of change in Matrix Table

I have used matrix table to show difference of sales in months of years 2016, 2017, now i have to add new column that shows % of change compared to same months every year.   Attached is the image o...
Need Help
sumit4732's avatar
sumit4732
Icon for Advocate II rankAdvocate II
9 years ago

Hi shzyincu,

 

I was suggesting that you create all 3 measure as mention in past reply and then pull all of them in Values, and let the column field be empty 

 

-Sumit 

shzyincu's avatar
shzyincu
Icon for Helper I rankHelper I
9 years ago

sumit4732 I did the expressions seperately and then made the third field, but still, what you mean by keep the column field empty? kindly if you can explain in detail?

  • sumit4732's avatar
    sumit4732
    Icon for Advocate II rankAdvocate II
    9 years ago

    Hi shzyincu,

     

    If you are goin for Metrix, there are three fields:

    1. Rows : put the column with month name here 

    2. Columns : dont place any column/measure here

    3. Values : put the three measures that you have created [for Year 2016 ], [for Year 2016 ], [for Diff]

     

    You can just use a simple table also now, just pull Month, [for Year 2016 ], [for Year 2016 ], [for Diff] in values.

     

    Hope this helps

    -Sumit

    • shzyincu's avatar
      shzyincu
      Icon for Helper I rankHelper I
      9 years ago

      sumit4732 this does not render the desired output then, 

      2. Columns : dont place any column/measure here, if i don't put YEAR field here, it sums up both years sales values in one column i need to show multiple columns for each year.

      • sumit4732's avatar
        sumit4732
        Icon for Advocate II rankAdvocate II
        9 years ago

        Hi,

         

        Aplogies if I was not clear the last time.

         

        I want you to create this three Measures,

        1. Year2016 =  CALCULATE(SUM(test[Value]),FILTER(ALL(test[year]),test[Year]=2016))

        2. Year2017 =   CALCULATE(SUM(test[Value]),FILTER(ALL(test[year]),test[Year]=2017))

        3. %diff= ([Year2017]/[Year2016])-1

        Now, in Metrix

        1. Rows : put the column with month name here (Jan, Feb, etc..)

        2. Columns : dont place any column/measure here

        3. Values : put the three measures that you have created [Year2016 ], [Year2017 ], [%diff]

         

        If this doesnt work please share screenshot with what proble you are facing.

         

        -Sumit