Drill down (level) on a pivot table

luismadriz — Tue, 28 Nov 2017 01:37:11 GMT

Hi community,

I'm using a drill down field on a pivot table.

Do you know how can I get the name of the field (level) currently being used on the pivot table?

In the above, if nothing is selected then County will be level being displayed... If only one County is selected and nothing else on the levels, then [Service Line] is supposed to be displayed... and so on. On the image above I'll need to know that "Specialty" is the field being used.

Any ideas? I thought in starting a big IF sentence to go over all levels and confirming if only one value of each is selected but I'm hoping there is a cleverer solution!

Many thanks for your help,

Cheers,

Luis

Re: Drill down (level) on a pivot table

luismadriz — Tue, 28 Nov 2017 05:48:16 GMT

So far this seems to show what the field being used should be:

IF (((GetSelectedCount(County)=1 OR GetPossibleCount(County)= 1) AND (GetSelectedCount([Service Line])=1 OR GetPossibleCount([Service Line])= 1) AND (GetSelectedCount(Specialty)=1 OR GetPossibleCount(Specialty)= 1) AND (GetPossibleCount([MD/DO vs APC])=1 OR GetSelectedCount([MD/DO vs APC])=1)),'PPEET',

IF (((GetSelectedCount(County)=1 OR GetPossibleCount(County)= 1) AND (GetSelectedCount([Service Line])=1 OR GetPossibleCount([Service Line])= 1)),'Specialty',

IF (((GetSelectedCount(County)=1 OR GetPossibleCount(County)= 1)),'[Service Line]','County'))))

I hope there was something more elegant...

Cheers,

Luis

topic Drill down (level) on a pivot table in App Development

Drill down (level) on a pivot table

Re: Drill down (level) on a pivot table