Row field values

[nareshthavidishetty]

Hi ,

We are having same Employee id with two different invoice numbers as below.

Here for location 2 for emp id 222 i need to show invoice numbers as 345,346 with in a single row.

Attached is the sample application.

Thanks..

[mbespartochnyy]

Hello,

One option is to create an expression that would concatenate invoice numbers. Attached is an example.

Mikhail B.

[krishnacbe]

Hi,

You can add a expression as Concat([Invoice #],';') and remove the Invoice # from Dimension.

[vishsaggi]

Or as it is a pivot table, you can move the location to top of the Sum(Sales) Like this. Will it work ?

[nareshthavidishetty]

Hi,

The current report design should have Invoice # as dimension.

Thanks..

[vishsaggi]

IS this a question or a statement? Your dim has Invoice # ...

[mbespartochnyy]

Try this (See attached). I've adjusted the script to concatenate the invoice numbers there. This way you can see both concatenated or individual invoice numbers.

Mikhail B.

[mbespartochnyy]

You can actually simplify the script even further. Here's a revised version.

[nareshthavidishetty]

Hi,

I have used the below logic in script,but it is giving the below error.

Logic:  Concat(A7BANB,';') as new,

Thanks..

[#10]

Use the Expression:

Concat ([Invoice #], ', ')

This will help you..