Text fields called in the expressions in pivot table are not showing all the values

[Anonymous]

HI Experts ,

i have mentioned few Text fields like product name , product brand in the expressions section in pivot table.

but all the values are not showing. only the first row comes up.

why is this happening ?? are'nt we supposed to call the non aggregated values in the expression section ??

Kindly help on this , this is kinda last moment issue and has to be fixed asap..

franky_h79‌youssefbelloum‌ any thoughts on this??

Thanks

[YoussefBelloum]

Hi,

would you be able to show us the issue using a screen shot ?

[Anonymous]

[Anonymous]

there are multiple product brand names and product names. is that the reason they are not showing up ??

beacuse if i pass a single product name as a filter the table shows the values.

[YoussefBelloum]

what did you use as expression for:

the working BUSINESS UNIT

the working PRODUCT FAMILY

the non working PRODUCT GROUP

?

[tresesco · Accepted solution]

Yes, the could be the reason. If you want to display all the values, you could try using concat(), like:

=Concat(Distinct [Product Name] , ',')

[Anonymous]

in expressions i have given as below,

for business unit expression = Businessunit

product name = product name

under one kind of business unit there are multiple product names, lets consider there are 3 product names under business unit 1 .

so in the table business 1 will come up, but in the product names column the values are shown as -.

which is null or missing,

how should this be handled ?

[YoussefBelloum]

Try tresesco suggestion

[Anonymous]

This doesn't seem to work Tresesco

[Anonymous]

tried , but no luck..

Any other thoughts to deal with this?