How to make calculated measure as a fixed column in column header ??

Answered
Himasree Vemuru asked on January 30, 2018

Hi Team,

My requirement is i need to display different status count across countries and along with the status i need to display the average beside to status.
For this i have drag and drop country as row, status as column and i have used average as measure.
Now, I have all the statuses repeated under average but i don't want to be statuses displayed again under average measure, i need to only total to be displayed as per my requirement.
 
Please help me on this.
 
Thanks.

4 answers

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster January 30, 2018

Hello Himasree,
Thank you for your question.
Could you please send us some screenshots which describe the necessary behavior? It would be much easier for us to find a suitable solution.
Waiting for the update from you.
Regards,
Dmytro

Public
Himasree Vemuru January 31, 2018

Sure.
I need report to look like in Report.jpg
but according to rows and columns placed, my report looks like in Output_Report.jpg

Public
Tanya Gryshko Tanya Gryshko Flexmonster January 31, 2018

Hello, Himasree,
Thank you for sharing additional details.
If we understand you correctly, you want to apply one aggregation for cells and different aggregation for total values. Currently, we don't have such feature.
Please let me know in case of any other questions.
Regards,
Tanya

Public
Himasree Vemuru February 2, 2018

Ok. Thank You..

Please login or Register to Submit Answer