7 Replies Latest reply: Jul 28, 2016 11:16 AM by Christian Wylezol RSS

    count and or aggr different dimension lines on one dimension entry

    Christian Wylezol

      Hi,

       

      i have a tricky Count to do and hope someone of you has a good idea.

      I have a Pivot-table with a structure (second column). The third column Shows the new adress and the forth column Shows the old adress.

      My issue is:

      The last column "pos" should count how much different "structure"-lines are used by this IFS-Konto entry "111110"

      The result would be in every "pos"-line 4.

       

       

      Does anybody of you can help me with that?

      I have nearly 1300 entries in the column IFS_Konto and Need to Analyse this quick.

      I thought of Count and aggr in combination but I dont get it to work.

       

      Thanks in advance

      Chris