Forum Discussion
binayjethwa
2 years agoHelper V
Avoid repeating values for multiple fields placed in matrix visual in Values section.
Hi , I have the following requirement , i have below table which i am showing in a matrrix visual . Rows: Emp no and name Columns : Category values : total count Now i need to calculate ...
- 2 years ago
I do not fully understand what you need, but look at my file, it can help you
binayjethwa
2 years agoHelper V
Hi Ahmedx ,
Here the values coming in Cat 1, cat 2 ... cat 5 are just a count of emp no , so in values section i have only count of emp no , now to have over all then i need to add another column or measure created for overall category and add in values section , now since it has Count of emp no and overall category in values , the table will show values for all categories twice. which i do not need. Is there any way we can achieve this.
here i need to create a measure or column for overall category and place it in values section below which will make matrix have repeatitive values of Count of emp no and overall category for all the categories.