values should not change

[ssriramin19]

Hello,

      My requirement is that I have a field called unit of measure which contains three values COGS,Selling Units and Price Units.

There is a straight table which has item numbers and sales values as measure.

In the table the sum of sales is sorted in descending order

which ever unit of measure I click the sales amount gets multipiled by corresponding unit of measure and the sales values are displayed in the descending order and the corresponding item numbers are listed .

The requirement is that whenever any unit of measure is selected the item numbers must be related to COGS unit of measure only . The actual quantity when multipled other than COGS need not be sorted in descending order .

Can anyone please  help me on to achieve the requirement .

Thanks

Sriram

[ssriramin19]

Please any one guide me hwo to resolve this issue..

[#3]

share your requirement in qvw and show by example

[ssriramin19]

The size of the file is very large it cannot be attached here .

[sujeetsingh]

Sri just create a inline table by it  with entering the 10 included records and then develope the UI in the same format you have in your dashboard or just with field names same reload your file with inline table .