Hi.
I'm struggling to fit the PivotGrid to my use case and can't seem to find any relevant example.
Basically, I have two group levels, let's say Product Category (first level) and then Product Name (second level, with each category containing one or more products). The Product Sale Amount is the numeric value I need to group on (Sum). The columns of the pivot will be the sale dates, in months. The problem is that products could be in different currencies, but each product is always in the same currency.
Would it be possible to have the Level 2 as "Product Name" + "Currency", as two adjacent columns? I can get the currency as a third level but that is not ideal since I need to unnecessarily expand an extra level.
Also, since it would be incorrect to sum amounts in different currencies, would it be possible to remove (or hide) the "Grand Total" column for Level 1 only?
Many thanks
Domenico
I'm struggling to fit the PivotGrid to my use case and can't seem to find any relevant example.
Basically, I have two group levels, let's say Product Category (first level) and then Product Name (second level, with each category containing one or more products). The Product Sale Amount is the numeric value I need to group on (Sum). The columns of the pivot will be the sale dates, in months. The problem is that products could be in different currencies, but each product is always in the same currency.
Would it be possible to have the Level 2 as "Product Name" + "Currency", as two adjacent columns? I can get the currency as a third level but that is not ideal since I need to unnecessarily expand an extra level.
Also, since it would be incorrect to sum amounts in different currencies, would it be possible to remove (or hide) the "Grand Total" column for Level 1 only?
Many thanks
Domenico