There are LOD calculations which we can use to exclude the pill from the view and them compute at the other levels.
Please post sample data or sample workbook.
Hi Shasank, thanks for the reply.
Attached is the detailed level excel work book with multiple sheets with multiple date/count information. As of now my data was like this. I am trying to create single crosstab table in tableau like in Sheet 10. Please help me out how to create the one.
Data.xlsx 75.0 KB