Calculation of Total Tax per Bill

[ramsqlik]

I have posted previously one request but it was marked as spam. My applogies if it is duplicate

I am new to Qlikview. So trying to create an output table from below input table. (Please igonore colour marking in every row. I have marked in colour for you to identify and differentiate  the data easily. Final Table I do not need any colour)

Currently I have data for multiple bills. Some bills may have more than one line items. I want to create a bill wise table as per below (All GST, Taxes sum together create one line item)

How do Do it?

Thank you

[avinashelite · Accepted solution]

This is simple in Qlikview rite , try like this 

Add dimension 

1. Bill Date 

2. Bill Number 

3. Vendor Name

Expressions :

Sum(IGST)

Sum(CGST)

Sum(SGST)

Sum(Total Tax)

Sum(Item Total) 

Sum(DISTINCT Sub Total) 

Sum(DISTINCT Total Amount) 

[ramsqlik]

Thanks it worked . Appreciate

[ramsqlik]

Since I have multiple line item, Is there any way I can get DISTINCT Bill NUmber?