Using PIPE in Evdre Dimension
I have a list of products which I want to show on a report . I need a blank row inserted right after a product , To show a seperate product.
I know i can acheive this by using row key range but I want to use a pipe symbol as a seperation . so that my report is not static . Because the number of products could be different.
I am not getting correct results when using pipe symbol . I must be using it in the wrong cell.
I used it in After range it didnot get the correct results.
My account members are
Total Net sales, Grossmargin,productcost
and the above accounts I show for each product in the report .
Please help with the syntax. Using NOEXPAND doesnt matter.
I have made a screenshot of my report http://img716.imageshack.us/img716/2893/pipeh.jpg
Hope it helps,