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

 

Parents Reply Children
No Data