Hi dear friends; its to share your experience as usual on the cross tab report design. I want to have names of suppliers as columns and category and specifica items as rows grwoupd by item categories. However, i need multiple formula fields for
---1. showing total price for category by each supplier(by adding unit prices give for each items under each category

---2. depending on the VAT field (true/false), I want to calculate 15% of total if true , zero if false


----3. finaly i need the grand taotal for each supplier for group of items to be summ of 15%VATof the item category and Total of the item category by ecah supplier

However, I can't handle such a felxibility in cross tab object. Any help in doing how will be appricaited with thanks.