Can you share sample workbook?
Thanks and regards,
Make your count a table calculation - i.e. WINDOW_SUM, WINDOW_COUNT, etc. You can tweak the 'Compute Using' setting to ignore certain dimensions on the view if required.
Please find the attached workbook. Whatever the measure that you were using at the top first convert them to dimension and pull them in to the rows shelf. Put the category (or you choice of dim) against the same in column shelf. Since Sum and profit are considered as dimensions they will appear as discrete in blue color. Make them Continuous. being Dimension they won't get summed up. Later you can directly put the Number of record to the chart which will get aggregated by category.
I hope this one helps. Let me know if things are still not clear.
Thanks and Regards,
Nice try, looks already bettter than mine.
Rather than adding the total count of records of particular interest would be to add the count of `0`s. That means only for the zero values its count would have to be displayed as a percentage of the total. Below almost an idea of how that would look like but in 2 different views instead - would be ideal if both could be integrated.
Thanks a lot