Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator II
Creator II

Need Help??

Hi Community,

I need help...

I have 2 drill downs, these are

1. Category-->HOD--->EmpName

2. Department--->HOD---->EmpName

can i use 2 drill downs in one chart...

Suppose 2 drill downs in dimension tab, expression sum(sales)

i want create one button.. if i am click button i want to change drill down dimension..

is it possible....????

1 Solution

Accepted Solutions
Anonymous
Not applicable

See attached.

No anything conditional on the chart level, everything in the drill down group itself.
Other solutions also valid of course.

View solution in original post

5 Replies
Anonymous
Not applicable

There are many ways to implement this, the simplest is probably to have two charts shown conditionally and switched by the button.  Typically I prefer not to increase the number of objects, if possible.  Try to use only one drill down group, where the first field is "conditional" - either Category or Department, depending on the button click.

paulwalker
Creator II
Creator II
Author

HI Michael,

PFA,

Please can you sample app...

mphekin12
Specialist
Specialist


Paul,

See if this will work for you.

Anonymous
Not applicable

something like this?

Anonymous
Not applicable

See attached.

No anything conditional on the chart level, everything in the drill down group itself.
Other solutions also valid of course.