How to change Bi publisher Template to get Splitted data
Hi Team,
I have requirement that , i need to split one row data in bi publisher report in to two seperate rows.Suppose i have one product in one region and used to get its data in one row ,now i need to split this product into Product1 and Prodcut2 to the same region and need to show in different rows. Can you please suggest me how to change the template?
Current report:
Jan-14 | Feb-14 | Mar-14 | Apr-14 | May-14 | Jun-14 | Jul-14 | Aug-14 | Sep-14 | Oct-14 | Nov-14 | Dec-14 | Total | |||||||||||||||||||||||||||||||||||||
CA | 30 | 40 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||
India | 10 | 50 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||
Total | 40 | 90 | 130 |
Now i need like this:
Jan-14 | Feb-14 | Mar-14 | Apr-14 | May-14 | Jun-14 |