Skip to Content
0
Former Member
May 13, 2011 at 10:00 PM

Using PIPE in Evdre Dimension

64 Views

Hi Experts,

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.

Thanks