I would like to group the following table (simplified), but the grouping should only take place if the PostingCode starts with "HOTEL":
Code: Select all
Date||PostingCode||Amount
01.10. HOTELVTI 100
01.10. HOTELVTN 10
01.10. BOX -10
01.10. TAX 5
02.10. HOTELVTI 50
02.10. TAX 5
02.10. HOTELVTN 10
02.10. MISC 12
Code: Select all
Date||PostingCode||Amount
01.10. HOTEL 110
01.10. BOX -10
01.10 TAX 5
02.10. HOTEL 60
02.10. TAX 5
02.10. MISC 12
Thanks for your help!