Forum Discussion
Matrix report trend value
I have a matrix report which has following values. But , need to show trend as seperate ICON at the top of the Matrix report. Trend should be Postive ,if All are Zeros in the difference value ...
Anonymous , Try like
if( countx(filter(summarize(Table, Table[state], "_1", sumx(Table, if(Table[source]-Table[Target]<0,1,0))),[_1]>0),[state]) >0, "Negative","Positive")Anonymous , Data is grouped at the state level first and then filtered and then aggregated gain
Thanks a lot. Its working perfect after making the changes as per my requriment.
Thank,Amit. Its working somehow. But need to do through testing for my entire report. Can you please explain me this syantax what is happening here?
amitchandak
Super User
Super UserAnonymous , Data is grouped at the state level first and then filtered and then aggregated gain
Thanks a lot. Its working perfect after making the changes as per my requriment.