Using Full Accumulation with variable

[zagzebski]

I want to be able to use a variable in tandem with a column that has cummulative reve % by product.

So I want to be able to use a slider that will show only the top ?% of revenue.

Example

Product     Revenue     Cummulative Rev%

A               100               10%    

B               600               70%

C               300               100%

In the example above if the user move the slider (variable) to 15% only product A would show, if they moved it to 70% then A and B would show, and so on.

[swuehl · Accepted solution]

You should get what you want using a slider with a variable and Dimension Limits in chart properties.

Check attached sample.

[zagzebski]

Awesome, thanks so much!

We have been using V10 so long I didn't even look into the Dimension Limits.

Steve

[paulyeo11]

Hi Sir

when i change the silde % from 0 to 100% , the 2 table does not change , do i miss out any thing ?

Paul

[swuehl]

Paul,

I am using dimension limits. What version of QV are you using?

[paulyeo11]

I am still 9

Sent from Samsung Mobile

[zagzebski]

So I built the object with the dimnesion limit and it worked well, However is it possible to build the second object below based on the slider (variable choice in the dimension limit)

\

Source Data:

Product       Region   Revenue    

A               East          50                   

A               West         50

B                East         200             

B               North         300

B               South        100 

C               South       300          

Object 1: Selection 70% on the slider would show only A and B

Product     Revenue     Cummulative Rev%

A               100               10%    

B               600               70%

C               300               100%

Object 2: How could I get a new object to respect the 70% selection (products) but show the Region they came from:

Region      Revenue

East           250

West           50

North          300  

South         100

Steve