Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a duplicate row appearing in my table. This look to be getting caused by the Award Value appearing twice in my table and when I bring it in as a dimension it duplicates the row. When I don't include Award Value in the dimension table then all the values appear on the one row which is what I'm trying to achieve.
Can anybody help?
are you doing any join to add Award category field to your main table?
or the associated table has a null [Award Category] for reference A01LV5SOUN16S with Fe Disc.. value at 57.4 quids!!
No there is no join.... the associated table has a null value
so it is not a dupe then!?
No its not a duplicate in back end table but only when drawn into the table but I want to merge the values and only have one line
Do you want to show the Null records for Award Category?
If not then you can check the "Suppress Null Value" for the Award Category.
Yes I do want to show them but I want all the values to be merged...
Can you upload a sample?
or i think you might have to do this
Dimensions:
Age,
Maintenance,
Reference,
Name,
AGGR(Concat(Distinct Award Category),Reference)
Expressions:
Sum(TotalPaid)
sum(Maint Paid)
Sum(Travel Paid)
SUM(ASN)
SUM(Study Exprense)
Sum(FE ChildCare)
Sum(FE Disc.)
Can you please share the qvw to debug and help you to fix the issue?
try with an expression instead of a dimension
concat(DISTINCT [Award Category], ',')