Help on Stacked reports

[#1]

Hi, I am creating a report and layout request products in the bottom listed all items, then Category on the top of products . Is there any way like SSRS of outside group so I can use the data set again instead of loading the data one or two more times.

	Qty	Sales
Total	100	12000
Category1	60	11500
Non-Category1	40	500
Category1	60	11500
Product1	30	10000
Product2	20	1000
Product3	10	500
Category2	30	300
Product1	20	100
Product2	10	200
Category3	10	200
Product1	8	100
Product3	2	100

Thank you so much.

[Gysbert_Wassenaar]

I don't understand what you're asking. What's the source data and what is the result you want to see?

[#3]

I do not have the source file. But the report come out should be like the above lay out.

Category1 repeat once and category2 and category3 combined as Non-Category1, then total in same level.

	Qty	Sales
Total	100	12000
Category1	60	11500
Non-Category1	40	500
Category1	60	11500
Product1	30	10000
Product2	20	1000
Product3	10	500
Category2	30	300
Product1	20	100
Product2	10	200
Category3	10	200
Product1	8	100
Product3	2	100

[Gysbert_Wassenaar]

If you don't have source data then you can't create the end result unless you're just creating your own fake data.

[#5]

Hi, Gysbert,

I made a fake data.

data:

OrderID	Category	Product	Qty	Sales
1	Category1	Product1	5	500
2	Category1	Product1	4	100
3	Category1	Product2	2	300
4	Category1	Product3	6	400
5	Category1	Product3	8	200
6	Category1	Product3	8	100
7	Category2	Product1	5	500
8	Category2	Product1	4	100
9	Category2	Product2	2	300
10	Category2	Product3	6	400
11	Category2	Product3	5	100
12	Category3	Product2	3	90
13	Category3	Product3	8	100
14	Category3	Product3	6	50
15	Category3	Product3	8	100

Report looks like:

Total	80	3340
Category1	33	1600
Non-Category1	47	1740
Category1	33	1600
Product1	9	600
Product2	2	300
Product3	22	700
Category2	22	1400
Product1	9	600
Product2	2	300
Product3	11	500
Category3	25	340
Product2	3	90
Product3	22	250

[#6]

Hi, guys, can anyone help me with my question please? It is an issue at work. I do not have a clue. I appreciate your help.

[Gysbert_Wassenaar]

See attached example

[Saravanan_Desingh]

Hi gwassenaar‌,

Can you please explain, how you format the two Pivot tables? I could not recreate it.

This is really nice. Thank you.

[Gysbert_Wassenaar]

You can enable the Indent option on the Style tab and you can use the Custom Format Cell option to change the background color of the headers. If you choose Design Grid in the View menu then you can right-click a header cell, choose Custom Format Cell from the context menu and change the formatting of the cell.

[Chanty4u]

chk dis

Select View -> View-Grid View  ->  right click your straight table select -> Custom Format Cell

and format as per your requirement

Custom Format Cells in Straight Table