4 Replies Latest reply on May 4, 2012 1:55 PM by Sean Marcoulides

    Merge two Dimensions

    Sean Marcoulides

      I have the following spreadsheet:

       

       

      StrategyFed Acct
      State Acct
      PracticeMeet AYPAA
      PracticeMeet AYPAU
      PracticeMissed AYPAA
      SummarizingMeet AYPAU
      SummarizingMeet AYPAA

       

      I need to merge the Fed Acct and State Acct Dimension to create bar graphs like:

                        

                          | Meet AYP    | Count 2

      Practice        | Missed AYP | Count 1

                          | AA              | Count 2

                          | AU              | Count 1

                         

                          | Meet AYP    | Count 2

      Summarizing | Missed AYP | Count 0

                          | AA              | Count 1

                          | AU              | Count 1

       

      I created a set with the Fed Acct and State Acct, now I see this:

       

                          | Meet AYP, AA    | Count 1

      Practice        | Meet AYP, AU    | Count 1

                          | Missed AYP, AA | Count 1

                          | Missed AYP, AU | Count 0

       

                          | Meet AYP, AA    | Count 1

      Summarizing | Meet AYP, AU    | Count 1

                          | Missed AYP, AA | Count 0

                          | Missed AYP, AU | Count 0

       

       

      Please help.