Dynamic changing of data in a pivot table by clicking the filter selections

[spartons]

Hi All,

the requirement is : I have a year filter with values from 2013 to 2023 and another filter Metrics as ABC, XYZ, DEF, PQR

in pivot table : If i select year filter value as 2013 and 2014  ,and Metrics as ABC

only those years data aggregation with respect to ABC metrics should be shown in pivot table. 

and if i select XYZ, ABC and all years in the Year filter, it should all years data for XYZ and ABC. Please help. 

[atotom93]

Not sure if I understand you, but that's how filters suppose to work. What is it that you are experiencing as a result?

[spartons]

those filters are inline tables which created backend