Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a drilldown group with Region, District and Territory. Now when i click on any Region it drills down to District, Clciking District drills down to Territory. Now if i am clicking on Territory only one Territory is selected and other territories get excluded. I want that even if i click on any Territory then all the Territories in a particular district should appear without excluding the other possible Territories in that particular District (i.e. it should not drilldown further after Territory). How this can be down ?
Finally got my answer.
if(GetCurrentField([DrillDownGroupName])= 'TERRITORY',
(SUM({$<%EPID={1}, Segment={'Splitters'},ZIP=, Name=,TERRITORY=>}(eTRx_Volume_Change))/
(SUM({$<%EPID={1}, Segment={'Splitters'},ZIP=, Name=,TERRITORY=>}(eTRx_Volume))-
SUM({$<%EPID={1}, Segment={'Splitters'},ZIP=, Name=,TERRITORY=>}(eTRx_Volume_Change)))),
(SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume_Change))/
(SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume))-
SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume_Change)))))
Thanks
maybe change the type of the group from drill down to cycle?
Regards
I can not do that. My requirement is such that i have to use Drill Down Group only.
What you can do, is build a trigger to prevent the selection of any Territory value. This trigger will undo any made selection on territory immediately.
Please see my attached example.
You can find the trigger at Document Properties -> Triggers:
- Document Event Trigger 'OnAnySelect'
- Field Event Trigger 'OnSelect'
Thanks for the reply JV. But can i do this for a particular sheet. Because i have to show the selections of territories inother sheets. Through this trigger i can not select territories in my entire report. But i want this to happen only for one sheet.
Hi JV,
I have given the action in sheet properties. It is working fine but the problem is when i am moving to the previous sheet where i had selected some territory the selections are lost. i have to maintain my territory selection when i move back to the first sheet but this action is clearing the selection of territories.
Hi,
I am afraid you cannot restrict this to a single sheet. Unfortunately the Sheet triggers are more limited.
You can apply this on an object by object basis by using set analysis:
{<Territory = >} will cause any selections in Territory to not affect the chart.
(I have also attached the above .qvw with this applied to the chart.)
Can you post a .qvw with sample data (or scramble the data that you already have)? I can't tell what is going on without actually seeing it.