Forums Retired Products and Controls
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
Close
Rohan
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
No Data
Reply
  • 138253
    Offline posted

    Hello Rohan,

     

    Thank you for your post. I have been looking into and I can suggest you see how to implement a custom aggregator in the feature browser under xamPivotGrid / Display / FlatData Aggregators section.

     

    Hope this helps you.

Children