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..
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.
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 ?