Hello and thank you in advance.
I have search the forum and have found people with similar issues, but I couldn't find an answer that could help me.. I'm sorry if I'm reposting an already asked question.
I am attempting to create a pricing report. I have different products and different prices for these products depending on the level. Example: Level one is orders under $500, Level 2 is between $500 and $1000, and Level 3 is over $1000.
I would like the report to look like this:
..............L1...L2...L3
Product 1 $50 $40 $30
Product 2 $45 $40 $35
Product 3 $70 $50 $30
Product 4 $45 $35 $25
Product 5 $60 $55 $50
Whenever I group it (either on level or product), the product appear 3 times. Like:
Level one
..Product 1 price
..Product 2 price etc
Level two
..Product 1 price
..Product 2 price etc
Level three
..Product 1 price
..Product 2 price etc
Or:
Product 1 Level one price
Product 1 Level two price
Product 1 Level three price
etc
Any suggestions? Sorry if this is so complex.. I thought it would be easier if I had visual examples...
Side question: can you use code to create reports? is it advised?
I have search the forum and have found people with similar issues, but I couldn't find an answer that could help me.. I'm sorry if I'm reposting an already asked question.
I am attempting to create a pricing report. I have different products and different prices for these products depending on the level. Example: Level one is orders under $500, Level 2 is between $500 and $1000, and Level 3 is over $1000.
I would like the report to look like this:
..............L1...L2...L3
Product 1 $50 $40 $30
Product 2 $45 $40 $35
Product 3 $70 $50 $30
Product 4 $45 $35 $25
Product 5 $60 $55 $50
Whenever I group it (either on level or product), the product appear 3 times. Like:
Level one
..Product 1 price
..Product 2 price etc
Level two
..Product 1 price
..Product 2 price etc
Level three
..Product 1 price
..Product 2 price etc
Or:
Product 1 Level one price
Product 1 Level two price
Product 1 Level three price
etc
Any suggestions? Sorry if this is so complex.. I thought it would be easier if I had visual examples...
Side question: can you use code to create reports? is it advised?