Order by

[Cjean2]

When trying to Add sales as a measure, It keeps on bringing up the sum of sales vs the sum of sales for each sales rep. In the KPI Margin Goal Chart.  Forgive me. I am new to this app and cant seem to find a resolution. Help!!!

[rubenmarin]

Hi, your question it's not clear, is your issue in the KPI or in the table? The table shows the same value for all rows, it looks like the SalesRep field it's not rlated to the sales table.

The sales table should have a SalesRep (or SalesCode or similar) field that creates a reationship with the table where SalesRep is loaded.

[SunilChauhan]

Sorting _> Just Drag field to top by which you want to Sort . Lets say you want to Sort by Date then keep Date at the top .

[Cjean2]

Thanks everyone. I resolved the issue