As you can see below I created an overall report which shows item, tax, mode of payment and all. As of now while I tried to create an report filtering ticket number with the product
for eg: As you can see that ticket number 160 occurs 4 times which totally depends on the different orders that I had placed. But the real issue is for each row as you can see I have cash payment of 1932 and also 5% GST have 92 on each row. so when it comes to taking total of these columns the total changes or gets doubled.
So I really need to clear this calculation error.
Is it really possible to divide the 5% GST and mode of payment by number of rows occurring on the specific ticket number ?
When designing reports it helps to know what you want to accomplish. That way you can get to the information you need much quicker. An example would be if your interested in just knowing how many items you sold, you would create a Orders report. If you want to know total money sales for a day(s) you would use a Ticket report.
However, the report you have could be use as a Pivot Table report. To make your report into a just add an ! to the first line, inside the first square bracket. Like this: [!TICKETS:8,10....
Then save the report. Exit out of the report designer go to Main Menu->Reports->View the report you just made. Then you can drag fields to where you would like display information (you will have to play around with a little to understand what is happening. When you get it looking the way you want, you will have to right click in the body of the report and select “Save Changes” on the dialog. Then every time you open the report that will be the default view. If you need to start over with the report, exit out of the reports module and go back into it (before saving). The report will revert back to the default view or your last save point.
I think some clown on the forum has a quick view of what you can do with Pivot Table reports.