I am attempting to calculate the percent of 3 different groups in a single qtr for the current ytd. Unfortunately, the calculation only does grand total. Is there a way to calculate based on qtr. Sample of table below
Thanks this helped, but found a limitation if I use a slicer. When i filter the report the slicer calculates percentage incorrectly since the slicer impacts the total count. Is there a way around this?