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,

 

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

 

 

 

 

 

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

sumit4732 that's fine, no need of appologies :)

kindly check in the attachment, Sales % Change and Samples % Change are getting repeated for both 2016, 2017, i don't want to show these two columns in the year 2016, i did resized the columns to hide it, but when i upload it on server, it does show the columns in 2016. I wanna removed these two from 2016 but don't wanna skip the year itself.