6 Replies Latest reply on Jun 18, 2018 2:08 AM by An Na

Create dynamic view of dual axis

Hi there,

Is there anyone who could help me with the following problem?

I created this worksheet.

In the first one you can see the Total "New Orders/Revenue" in the second one per Segment.

I could also create a dual axis in this view, so you can see it all in one graph:

I would like now, that if the User selects "All" that i can only see the line for the Total "New Orders/Revenue" and if the User selects for example "a" that he can only see this line.

I tried to combine the two calculations but it doesn't work. Any ideas how to solve this problem?

Thank you very much.

Best,

Anna

• 1. Re: Create dynamic view of dual axis

Hi Anna,

Create parameter and get this done.

Refer attached.

Thanks

sankar

• 2. Re: Create dynamic view of dual axis

Hi Sankar,

perfect it works, but the problem is, in the 'All' view i see the different Segment figures and not the figures of the 'Total' value because of the 'Segment' in the 'Marks' Section:

Is there a solution that i can see it like that?

I would also like that the user is able to select the segment with this kind of boxes and not with the parameter control:

So that if the user marks 'a' he can see only Segment 'a' and if he selects 'a' and 'b' that he can see both and if he selects all "Boxes", he sees the Total?

Thank you very much.

Best,

Anna

• 3. Re: Create dynamic view of dual axis

Hi anna,

By default total will display and any segment selected then it will display per segment.

Refer attached workbook.

• 4. Re: Create dynamic view of dual axis

Hi Sankar,

i understand what you did, but when i select the 'All' button it displays the Sum over all Segments, but i would like to show the Overall 'Total Calculation': [New Orders/Revenue] and not the Calculation per Segment: [New Orders/Revenue  per Segment].

Is this also possible?

Thank you.

• 5. Re: Create dynamic view of dual axis

hi anna,

changed calculation in view. Please check.

Thanks

Sankarmagesh Rajan

Mob:+919894170397

BI, Aspire Systems (India) Pvt Ltd