Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
420
Add % as measure in Pivot Grid
posted

Hello,

I have following observable collection: (Columns represent properties of class Product)

ID             Name                           Division               Sales

1               Levis Jeans                MENS                   £1,34,234.00

2               Levis Shirt                   MENS                   £2,32,312.00

3               Provouge Jeans        MENS                    £1,42,345.00

4               Levis Jeans                WOMENS             £1,89,234.00

5               Levis TShirt                 WOMENS             £1,00,534.00

 

 

I want to display this data in pivot in below mentioned format:

Division                Sales                         Sales %

MENS                  £5,08,891.00            63.7181826%

WOMENS           £2,89,768.00           36.2818174%

Grand Total       £7,98,659.00            100.0%

 

 

 

Here, I am not able to find out the % sales per division in pivot grid. Please let me know, if this is possible using custom aggregator.

 

 

Let me know if you need any clarification.

 

 

Thanks in advance...

Rohan