11 Replies Latest reply: Aug 22, 2013 5:37 AM by vv reddy RSS

    Re: Sub Totals

      Hi All,

       

      I have two excel files contains tablesTab1, Tab2 AS follows

       

      Tab1:

       

      Staffing Profile Identifier

      Project num

      Project Name

      Demand Resource

      707963

      220981

      QV_Dev

      4

      707964

      209892

      QV_Dev

      6

      707965

      209892

      QV_Dev

      5

       

      Tab2:

       

      Profile Identifier

      Project Name

      Allocated Resource

      707963

      QV_Dev

      1

      707963

      QV_Dev

      2

      707964

      QV_Dev

      3

      707964

      QV_Dev

      2

      707965

      QV_Dev

      3

       

       

      But Output will be in PIVOT or STRAIGHT TABLE as follows

       

      Profile Identifier

      Project Number

      Project Name

      Demand Resources

      Allocated Resource

      Gap

      707963

      220981

      QV_Dev

      4

      3

      1

      707964

      209892

      QV_Dev

      6

      5

      1

      707965

      209892

      QV_Dev

      5

      3

      2

       

       

       


      i tried it using
      if((Staff Profile Identifier=Position Identifier),Allocated Resource,0) in Expression and i used calculated dimension also, but sometimes it works well and some times got errors.

      Please Find attached Screen shots.

       

      PLEASE Can any one look into issue, GIve me Solution.

       

       

       

      Thanks,

      MVReddy.

        • Re: Hi
          jagan mohan rao appala

          Hi,

          Can you attach the sample file?

           

          Regards,

          Jagan.

            • Re: Hi

              Please Respond Anyone to this issue, It's Urgent Requirement!

               

              Thanks To All for Your Valuable Reply,

               

              Now i'm attaching sample QVW and my requirement is 'Position IDentifier' repeated and taking 'Allocated Resources' values repeatedly, but i want only one 'Position IDentifier' value for this i want to add multiple 'Allocated Resources'(Belongs to same 'Position Identifier') and substract them with 'Demand Resource(it's a single value)'

               

              it's Urgent Requirement, i'm waiting for your reply.

               

              Please Respond Anyone to this issue, It's Urgent Requirement!

               

              Thanks,

              Reddy

            • Re: Hi
              Stefan Wühl

              Not sure what you've done to your other thread, but AFAIR I tried to answer your question there.

               

              No multiple posts regarding the same issue, please, it makes it hard to follow a discussion.

                • Re: Hi

                  Hi swuehl,

                   

                  I'm sorry about that and now my requirement has been changed thatswhy i posted in Post.

                   

                  Please look into the issue, it's Urgent.

                   

                   

                  Thanks,

                  MV Reddy

                • Re: Hi
                  Gabriel Oluwaseye

                  Hi,

                   

                  Experts here will love to help resolve this issue. However, you have not provided enough explanation, i.e. what result you want, what the issue is? e.t.c

                   

                  Kindly provide more information.

                   

                  From what I can glean from little inforamtion you provided above, it sounds as if you wanted to join both TABS (TAB1 & TAB2) together. If that's the case. I will suggest you use JOIN functionality.

                   

                  Hope this help and look forward to more explanantion

                   

                  Best Regards,

                  Gabriel

                  • Re: Sub Totals
                    pradeep t

                    We can achieve this using simple Join. (Join on Profile Identifier)

                    I have done the bellow process.

                    1. Load the first tab

                    2. While Loading the second tab use the "Group By" and "Sum" functions.

                    3. In chart, use the expression as  "=Demand-Actual"