April 9, 2010 at 6:45 am
My original report is grouped by customer and looks like this:
Customer / Product / Sales$$
1 1 5
6 3
Total 8
2 7 6
4 1
6 3
Total 10
3 5 22
Total 22
TOTAL 40
I want to collapse it so that it looks like this:
Customer product Sales$$
1 8
2 10
3 22
TOTAL 40
I set the visibility on product to hidden and set the toggle property to toggle by customer
I then get this:
Customer / Product / Sales$$
1 5
3
TOTAL 8
2 6
1
3
Total 10
3 22
TOTAL 22
TOTAL 40
In addition to the problem with the lines that show the detail sales $$ but no product, when I expand the customer I get the top product only, I do not get them all. So it would look like this
Customer / Product / Sales$$
1 1 5
3
TOTAL 8
2 6
1
3
Total 10
3 22
TOTAL 22
TOTAL 40
What am I doing wrong?
April 19, 2010 at 7:52 am
You need to set its control visibility. I have attached a screenshot as an example, hope this helps...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply