I have create a page which contains:
1. A Group where I can filter with:
- Date Filter from table Item
- Item Ledger Entry Type from table Value Entry
- Entry Type from table Item Ledger Entry
2. A Group -> Repeater where I have
- No. from table Item
- Description from table Item
- A variable Purchase where I need to calculate total for all entries with type Purchase in the date filter
How can calculate that when I filter with Item Ledger Entry Type -> Purchase, I will have the total for all entries with type Purchase and when I filter with Entry Type -> Purchase I will have the total for all entries with type Purchase?
Can you advise me how to this?