Hi, Jagurhti. Does this image show what you are asking? The attached workbook includes this solution.
Here are the steps I used:
- Removed the existing column grant totals.
- Went to CSR Name in rows and unchecked Show Header.
- Went into Analysis > Totals > Show Column Grand Totals.
remove-header-137880.twbx 19.9 KB
Thanks much for suggestion.
Can we remove all the line details, just showing the total against the department.
Department Name | SalesOrderCount | CSRCount
IC 2167 7
Appreciate your help!!
Yes. Here is an image capture. The attached workbook shows this revised worksheet. You can follow the steps I include below to go from the original workbook I posted to the workbook attached to this post.
Steps to get from the first view to this view:
1) Remove CSR Name from the Rows
2) Remove the grand totals via Analysis > Totals > uncheck Show Column Grand Totals
When the CSR NAme is not dispalyed on the sheet, the CSR count is changed from 7 to 12.
Is there any workarround t get the CSR count fixed?
Thanks for pointing that out. I didn't see that. Understanding the scope of aggregates and controlling aggregation in Tableau is hard.
Attached is a further revision of the workbook. Here's an image:
I removed the SUM() aggregate function in the csr count calculated field. I also changed the result from using the count() aggregate function to use just the integer value 1. Then, to obtain the 7, I sum the csr count outside the calculated field.
The scope of the aggregates change when they are not use in the calculated field.
I think there are a couple of other solutions. This is just one.