Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set analysis for Commercial KPI's

I am currently building a commercial KPI dashboard.

What I want to do is set a number of charts that only utilise restriced selections from one column called 'DIVISION'

DIVISION ranges from 1-22 so I am trying to get the same chart, but each one to only choose from a set number of divisions.

Example:

DIV                              CHART 1                        CHART 2

1                                    DIV 1 & 5                         DIV 2 Only

2

3

4

5

6

The expression can be changed as this isn't the issue what is being calculated, it is the data that is being considered in all charts currently that need restricting.

Thanks

1 Solution

Accepted Solutions
trdandamudi
Master II
Master II

May be as below: (I am using version 12)

View solution in original post

3 Replies
trdandamudi
Master II
Master II

May be as below: (I am using version 12)

Anonymous
Not applicable
Author

This seems it will work with some small amendments,

Thanks Thirimala

trdandamudi
Master II
Master II

You are welcome...