When I go to "Table Viewer" right click to preview the "Dialog" it shows my information but when I create a new "Chart" or "Table box" it shows me less information. the "Dialog" previewer shows me 4 records but the "Chart" or "Table box" shows only 2 records.
What would cause the Dialog box be different from a table or chart?
thank you in advance!
Solved! Go to Solution.
that's correct I was just trying to give you more samples on were the records are not displaying properly. it seems to only work when I create a basic Chart using SUM(Quantity) and not just Quantity. I shouldn't have to do this it should just display the same as the Database (Dialog box).
So the Column which has unique values are Quantity.
If you add Quantity as your Dimension the issue will be solved I Hope. for expression just add 1 and hide that column in Presentation tab.