I have a use case where in i want to view the data using multiple drop down filters. My problem here is when there is no filter applied i.e. when All values are selected the values in the bar graph is calculated based on the total count of All values (say the calculation will be based on Total Technicians).
But when i apply any filter, the calculation will be based on the count of Technicians selected in that filter.
Hence values in bar graph are varying for the same filter value when applied and when not applied. I don't want the values in Bar graph to be changed when the same filter value is being viewed.
Please help me with an example on how to handle such cases.
Please share a sample workbook screenshots so we can better understand this issue