Hi,
I created an excel template based bi publisher report using sql query.
Expected Output
Country | Region | State | County | Item | Sales |
|---|
Germany | North | W1 | C1 | Laptop | 20 |
| | | | Mouse | 22 |
| | | | Coffee | 100 |
| | | C2 | Laptop | 33 |
| | | | Mouse | 31 |
| | | | Coffee | 311 |
| | W2 | C3 | Laptop | 87 |
| | | | Mouse | 88 |
| South | W3 | C5 | Laptop | 11 |
| | | | Mouse | 12 |
| | | | Coffee | 12 |
| | W4 | C6 | Laptop | 11 |
| | | | Mouse | 12 |
| | | | Coffee | 12 |
Spain | North | S2 | C9 | Laptop | 20 |
| | | | Mouse | 22 |
| | | | Coffee | 100 |
| | | | Laptop | 33 |
| | S3 | C12 | Mouse | 31 |
| | | | Coffee | 311 |
| | | | Laptop | 87 |
| | | | Mouse | 88 |
| | S5 | C14 | Laptop | 11 |
| | | | Mouse | 12 |
| | | | Coffee | 12 |
| | | | Laptop | 11 |
UK | Central | L1 | C43 | Mouse | 12 |
| | | | Coffee | 12 |
| | | | | |
Actual output that I get
Country | Region | State | County | Item | Sales | |
|---|
Germany" xdoexcel:rowMark="2 | North" xdoexcel:rowMark="3 | W1" xdoexcel:rowMark="4 | C1" xdoexcel:rowMark="5 | Laptop | 20 | |
| | | | Mouse | 22 | |
| | | | Coffee | 100 | |
| | | C2" xdoexcel:rowMark="5 | Laptop | 33 | |
| | | | Mouse | 31 | |
| | | | Coffee | 311 | |
| | W2" xdoexcel:rowMark="4 | C3" xdoexcel:rowMark="5 | Laptop | 87 | |
| | | | Mouse | 88 | |
| South" xdoexcel:rowMark="3 | W3" xdoexcel:rowMark="4 | C5" xdoexcel:rowMark="5 | Laptop | 11 | |
| | | | Mouse | 12 | |
| | | | Coffee | 12 | |
| | W4" xdoexcel:rowMark="4 | C6" xdoexcel:rowMark="5 | Laptop | 11 | |
| | | | Mouse | 12 | |
| | | | Coffee | 12 | |
Spain" xdoexcel:rowMark="2 | North" xdoexcel:rowMark="3 | S2" xdoexcel:rowMark="4 | C9" xdoexcel:rowMark="5 | Laptop | 20 | |
| | | | Mouse | 22 | |
| | | | Coffee | 100 | |
| | | | Laptop | 33 | |
| | S3" xdoexcel:rowMark="4 | C12" xdoexcel:rowMark="5 | Mouse | 31 | |
| | | | Coffee | 311 | |
| | | | Laptop | 87 | |
| | | | Mouse | 88 | |
| | S5" xdoexcel:rowMark="4 | C14" xdoexcel:rowMark="5 | Laptop | 11 | |
| | | | Mouse | 12 | |
| | | | Coffee | 12 | |
| | | | Laptop | 11 | |
UK" xdoexcel:rowMark="2 | Central" xdoexcel:rowMark="3 | L1" xdoexcel:rowMark="4 | C43" xdoexcel:rowMark="5 | Mouse | 12 | |
| | | | Coffee | 12 | |
Loops applied:
For each Country
Subgroup: for each region
Subgroup: for each state
Subgroup: for each county
Subgroup: for each Item
