Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I loaded a table and created a pivot chart with only with some dimensions and with a unique policy number.
Now I want to show a entire records from the original table when the user is on only one policy number.
I created a table box and added all the dimensions to it and given condition to show the records related to the selected policy number only.
But I am not able to see all the records. Somehow its discarding some of the records.
Could I know the reason.
Thanks
Pavan
Are you sure you do not have any duplicate records?
Try adding a new dimension to your table on the load script:
RecNo() as RecordNumber
Then include this new dimension, RecordNumber to your table.
Also check that count(distinct YourRecorId) = count(RecordNumber).
Hi
Please post some sample data.
could you telll me how to just dump entire table onto dashboard??
Are you sure you do not have any duplicate records?
Try adding a new dimension to your table on the load script:
RecNo() as RecordNumber
Then include this new dimension, RecordNumber to your table.
Also check that count(distinct YourRecorId) = count(RecordNumber).
Hi Pavan,
Can you post an example QVW file?
thanks,
Rajesh Vaswani
Thanks Jose Its working
The table box is showing only related records.
But when I do sum on one column its taking lot of values other than selected policy number.
Does RecNo() effect the calucualtions.
Thanks
Pavan
RecNo() should not affect your calculations. Think of it as an autonumber id column.