Forum Discussion
Statistics Summary
Hi,
I'm a new user. I have a general query regarding summary of statistics chart. I have evaluated the values using measures, however I'm facing challenge to summarize them in one chart/table in reports. I want the expressions as column headers i.e income, exp, variable 1, variable 2, etc and the stats value as in multiple rows. Please refer the sample data:
| Income | Exp | |
| Mean | 51000 | 40000 |
| Median | 45000 | 32000 |
| Min | 24000 | 21000 |
| Max | 80000 | 60000 |
I tried to use the columnstatistcs(), however got error that states, "multiple columns and can't scale multiple columns".
Please share your thoughts and guide me.
Thanks
Deepak
2 Replies
- amitchandakSuper User
deepak101 , calculation group can help. I have dicussed here
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0
- deepak101Regular Visitor
Thank you for the guidance.
I will go through your tutorial, test my dataset accordingly and let you know the results.