Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I don't understand what you're asking. What's the source data and what is the result you want to see?
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 |
If you don't have source data then you can't create the end result unless you're just creating your own fake data.
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 |
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.
See attached example
Hi gwassenaar,
Can you please explain, how you format the two Pivot tables? I could not recreate it.
This is really nice. Thank you.
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.
chk dis
Select View -> View-Grid View -> right click your straight table select -> Custom Format Cell
and format as per your requirement