cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
trafferty Frequent Visitor
Frequent Visitor

Count Across Table of Number of Products with Total Product Amount

I am trying to figure out how to create a visual like this:

Product Total Product Count Total Amount
Cadency3    315,413.04
RNET4    215,749.07
Trecs3      57,600.00
UPCS2      10,000.00
Smart Analysis15000
TOTAL13    603,762.11

 

From my table like this:

Row LabelsProduct 1 Product 1 Amount Product 2Product 2 AmountProduct 3Product 3 AmountProduct 4Product 4 Amount
Vao - Exhibit 11 - Mixed -  Implement RNET and CadencyCadency                  187,855.03RNET             104,308.12Trecs23800UPCS5000
LPL Mart- T&M - Exhibit C - Implement Cadency + ReconNETRNET                     52,875.28Cadency               30,213.18 0 0
Wilbur - T&M - SOW 6725 - Upgrade RNET and ANETRNET                     45,400.00Trecs               23,800.00 0 0
KSG- Schedule A-1 - Mixed - Migrate Certification to Cloud & Implement ReconNETCadency                     97,344.83RNET               13,165.67 0 0
Proque- Fixed Bid - SOW 6703 - Migrate RNET and Certification to CloudTrecs                     10,000.00UPCS                 5,000.00Smart Analysis5000 0
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Count Across Table of Number of Products with Total Product Amount

Hi @trafferty,

 

To get your desired output, you could follow the steps below.

 

1. Go to Query Editor and duplicate the table for 3 times, then you will get 4 tables.

 

2. Keep column  Row Labels, Product 1,Product 1 Amount and remove other columns in table 1, then rename the Product 1 to Product and Product 1 Amount to Product  Amount and you will get the table like below.

 

table1.PNG

3. Do the same options for table 2, table 3 , table 4.

 

4. Click Append Queries as New.

append.PNG

5. Apply and Close and then you could create the table like below.

 result table.PNG

 More details, please refer to the attachment.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: Count Across Table of Number of Products with Total Product Amount

Hi @trafferty,

 

To get your desired output, you could follow the steps below.

 

1. Go to Query Editor and duplicate the table for 3 times, then you will get 4 tables.

 

2. Keep column  Row Labels, Product 1,Product 1 Amount and remove other columns in table 1, then rename the Product 1 to Product and Product 1 Amount to Product  Amount and you will get the table like below.

 

table1.PNG

3. Do the same options for table 2, table 3 , table 4.

 

4. Click Append Queries as New.

append.PNG

5. Apply and Close and then you could create the table like below.

 result table.PNG

 More details, please refer to the attachment.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
trafferty Frequent Visitor
Frequent Visitor

Re: Count Across Table of Number of Products with Total Product Amount

Thank you for the step by step on how to achieve this! Worked just like you showed.

Super User
Super User

Re: Count Across Table of Number of Products with Total Product Amount

Hi,

 

Here's a way to do it without creating 3 copies of the Table.

 

Hope this helps.