1 Reply Latest reply: Nov 28, 2017 12:48 AM by Luis Madriz RSS

    Drill down (level) on a pivot table

    Luis Madriz

      Hi community,

       

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

      Untitled1.png

       

      Untitled2.png

       

      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
          Luis Madriz

          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) AND (GetSelectedCount(Specialty)=1 OR GetPossibleCount(Specialty)= 1)),'[MD/DO vs APC]',

          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