Cross Tab Query

0

Hi All,

I have customized a cross tab report.I need help in consolidating the data in one a single detail section of the crosstab, please refer the screenshot attached

  /sites/default/files/files/Crosstab_Example.PNG

The desired report should look like the below :

    No. of Policies No. of Lives Gross Premium
Channel CH01 1000 1800 $200,000 
  Branch1 250 500 $50,000 
  ProductA 100 250 $20,000 
  ProductB 75 100 $15,000 
  ProductC 75 150 $15,000 
  Branch2 750 1300 $150,000 
  ProductD 500 1000 $100,000 
  ProductE 250 300 $50,000 

Please let me know the solution to this.

aashnanahar's picture
Joined: Mar 16 2017 - 12:49am
Last seen: 2 years 1 month ago

Hi ALL,

has anybody tackled this scenario before...please help

aashnanahar - 2 years 8 months ago

0 Answers:

No answers yet
Feedback
randomness