Forum Discussion

Tg20188's avatar
Tg20188
Regular Visitor
4 years ago

How to add two rows?

Hello All!!   I'm quite new to PQ. I working with not very large dataset and I'm facing a bit challenge. I have one query which looks like this:   Column 1   Column 2 40001           Amount 1 ...
Need Help
Tg20188's avatar
Tg20188
Regular Visitor
4 years ago

Hello everyone,

 

apologize I didn't provide responses.

I wanted to attach an example.

 

- "Financial data" tab is my dataset

- "Mapping" is basically mapping of Account #s in "Financial data"

- Each account has one of two values assigned: "Gross" or "Ceded"

 

When building Pivot table i want to have Gross and Ceded values in rows and Accounts in columns. This works fine. What I'm struggling with is how to add "Gross" and "Ceded" aggregations to calculate "Net" (which is sum of "Gross" and "Ceded").

I also added to the attached file "Output" tab which is just static presentation what i want to achieve.

 

let me know if this support helps. and thank you in advance for help 🙂

 

https://docs.google.com/spreadsheets/d/1AdEmeik50VrC-5ZQOz2EbJc00lCpXXu0/edit?usp=sharing&ouid=111159354396280446927&rtpof=true&sd=true 

  • KNP's avatar
    KNP
    Super User
    4 years ago

    Still need more detail.

    From the mapping table, an account appears to be one or the other, never both Gross and Ceded.

    So from what I can see in your sample data this would be your output...

      Account 1 Account 2 Account 3 Account 4 Account 5 Account 6
    Gross 100 100 -20      
    Ceded       30 150 200
    Net 100 100 -20 -30 -150 -200 

     

    What am I missing?