0

simple two group by

Ushikawa Kazumasa

November 27, 2020 01:03

None

Follow

Vendor No.
Date No. Code LineNo. Amount
--------------------------------------------
000774001
9/9 000774001 1000 Z013005010 43000

                                         Subtotal 43000

--------------------------------------------
369088001
9/9 000774006 1000 Z013005010 43000
9/9 000774010 1000 Z013005010 40000
9/10 000774012 1000 Z013005010 40000
9/10 000774015 1000 Z013005010 40000

                                           Subtotal 83000

--------------------------------------------

I can make function like below function

=NL("Rows=4","Purch. Inv. Header","Code","Posting Date",Options!$G$6)

However, I would like to add one more grouping like below
How can I do that

 

Code
Date No. Code LineNo. Amount
--------------------------------------------
000774001
9/9 000774001 1000 Z013005010 43000

                                 daily subtotal 43000

                                         Subtotal 43000

--------------------------------------------
369088001
9/9 000774006 1000 Z013005010 43000
9/9 000774010 1000 Z013005010 40000

                                 daily subtotal 83000

9/10 000774012 1000 Z013005010 40000
9/10 000774015 1000 Z013005010 40000

                                   daily subtotal 80000

                                         Subtotal 163000

--------------------------------------------

 

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Ushikawa Kazumasa November 27, 2020 01:08

  I want group by Vendor No. and date.

   

   

  VendorNo

  Date No. Code LineNo. Amount
  --------------------------------------------
  000774001
  9/9 000774001 1000 Z013005010 43000
  
                                           Subtotal 43000

  --------------------------------------------
  369088001
  9/9 000774006 1000 Z013005010 43000
  9/9 000774010 1000 Z013005010 40000
  9/10 000774012 1000 Z013005010 40000
  9/10 000774015 1000 Z013005010 40000

                                             Subtotal 83000

  --------------------------------------------

  I can make function like below function

  =NL("Rows=4","Purch. Inv. Header","VendorNo","Posting Date",Options!$G$6)

  However, I would like to add one more grouping VendorNo and Date
  How can I do that

   

  Vendor No
  Date No. Code LineNo. Amount
  --------------------------------------------
  000774001
  9/9 000774001 1000 Z013005010 43000

                                   daily subtotal 43000

  
                                           Subtotal 43000

  --------------------------------------------
  369088001
  9/9 000774006 1000 Z013005010 43000
  9/9 000774010 1000 Z013005010 40000

                                   daily subtotal 83000

  9/10 000774012 1000 Z013005010 40000
  9/10 000774015 1000 Z013005010 40000

                                     daily subtotal 80000

                                           Subtotal 163000

  --------------------------------------------

• 0
  
  Amy W December 03, 2020 18:52

  If everything you need is coming from the same table, you can easily build a grouping report with the Report Wizard.

  https://support.jetglobal.com/hc/en-us/articles/219402337-The-Report-Wizard 

   

  If not, take a look at this tutorial on Multi-level Grouping Reports.

  https://support.jetglobal.com/hc/en-us/articles/219403067-Multi-level-Grouping-and-Subtotaling-Tutorial

   

   

• 0
  
  Ushikawa Kazumasa December 10, 2020 01:18

  Thank you very much.

  It looks working.