amit.saini Posted March 16, 2017 Share Posted March 16, 2017 Hi, Below is the crosstab template where we have 3 dimensions and 3 measures. Need help, if channel, branch & product are row groups and measures are Policies, lives & Premium then what would be the column groups. How we achieve the same cross tab.Jaspersoft does not allow measures as columns. However, column groups are a mandatory element of the cross tables No. of PoliciesNo. of LivesGross PremiumChannelCH0110001800$200,000 Branch1250500$50,000 ProductA100250$20,000 ProductB75100$15,000 ProductC75150$15,000 Branch27501300$150,000 ProductD5001000$100,000 ProductE250300$50,000 Link to comment Share on other sites More sharing options...
amit.saini Posted March 21, 2017 Author Share Posted March 21, 2017 Anybody help me out on this pls. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now