Data that is visible in tablebox, not visible in table/pivot chart?

[Anonymous]

Hi, I've created an xref table so that I when a user selects a server, it automatically pivots to all of the applications on that server. This view is visible in a table box, but not visible when I try to visualize it in a table or pivot chart. Below are images that show;

1. The table box output next to the pivot chart output next to the server selected.

2. The relationship manager view.

Thoughts?

[vishsaggi · Accepted solution]

Can you remove synthetic keys by creating a Key or renaming fields like

for table v_cm_sc_infra_xref

LASTID,

SERVER AS xref_Server

then reload the data and see. IF not can you post this qvw file for a quick look.

[m_woolf]

What is your expression in the pivottable?

[Anonymous]

That fixed it. Thanks!