Forum Discussion
Add extra columns in matrix visual
Sorry if there is any similar issue. I am stuck with an issue and need this issue solve soon. Please let me know any suggestions or tips and tricks or anyway i can clear this. I have table1 and ta...
Hello All,
Just need to know if this is possible. Please do let me know .
Measure Stat1 = SUM(Table1[Trx]) / SUM(Table1[Samples])
Measure Stat2 = SUM(Table1[NetSales]) / SUM(Table1[Samples])
I have YTD and LYTD measures also.
Can I get the result in the matrix as shown below. Please let me know with the solution.
| Statistic | November | December | Current YTD | Previous YTD | Change in YTD | Percent |
| Stat1 | ? | ? | ||||
| Stat2 | ? | ? |
Note Stat1, Stat2, CurrentYTD, PreviousYTD ,Change in YTD and Percent are all measures. If it is not possible to do with measures then suggest me with some other way. I have been trying this from many days. Thanks in advance.