I have a table with 3 date groups. Current year , previous year and forecast. I need to make 3 identical tables pivot tables one with each date type as a filter. meaning one for current year , one for previous year etc.
You can add a filter to the expressions in your pivot charts. Suppose you have an expression sum(Sales). You can change it into sum({<DateGroup={'Current year'}>}Sales). This will first calculate a set for the chart that filters the records on the field DateGroup to consider only those with value 'Current year'. This set is then used by the chart to calculate the sums of the field Sales for the chart dimensions.
