Pivot Table, wrong dimension grouping

[#1]

Hi there,

I've been using for a while the Pivot Table and in the last project that I've been involved we've noticed a weird behavior on that element. For some reason when I expand a value of the dimension (in that case Country), the dimension spread into two groups the TOTAL row and the actual values.

As you can see in the picture seems that the first row of AF is showing the Total value, but I don't know why that row it's not linked to the real data.

Do you have any idea what might cause this behavior?

Thank you in advance.

Best Regards,

Carlos

[#2]

Can you pls share some sample data....

[rahulpawarb]

Hello Carlos,

Sorry, your requirement is ambiguous. Please elaborate further by providing sample data and expected result.

Regards!

Rahul

[#4 · Accepted solution]

Hi there,

Sorry if it wasn't clear the question.

That table it's made using a dimensions on a LinkTable.

However, I've been searching more deeply in the matter and I've just found the issue.

It's was due to the null values on the link table, I've replaced the null values by script (make it selectable ---- if(isNull(field1), '-', field1) as field1))

Now seems to be working.

Sorry again for the ambiguous question.

Thank you,

Carlos.