How to show summary levels dynamically for automatic update of chart

Options
nishantgarg
nishantgarg Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

Hi, I have a module with time and client list as dimensions. The client list looks something like this:

Economy Clients

- Economy Client 1

- Economy Client 2

Premium Clients

- Premium Client 1

- Premium Client 2

The line item, for example, is Revenue. I published the line item as a chart by manually selecting only the Summary levels, i.e. the bar chart with bars showing revenue for Economy Clients and Premium Clients on a time axis.

 

However, now I added a 3rd category, so my list looks something like this:

Economy Clients

- Economy Client 1

- Economy Client 2

Premium Clients

- Premium Client 1

- Premium Client 2

Luxury Clients

- Luxury Client 1

 

However, the chart does not update automatically as it's not dynamic. Is it possible to dynamically select only the summary levels using a filter in the module? I want to republish the chart but want to make it dynamic so that in future if I were to add more client categories, the chart updates automatically.

 

Appreciate your help on this.

 

Best,
Nishant