Limiting the data in spotfire

[abhinandan yavagal]

Hi ,

Here is the situation.

Suppose I have n columns , say Part Number ,inventory quantity, inventory location etc.

I have a KPI chart for part numbers which also displays the inventory quantity.

My inventory location has location A, B, C, D

I want my KPI to display only the sum of a particular part inventory located only in location 'A'.

How do I do this

 

Thanks in advance

[Richard Pobi]

Try this, go to KPI Settings. Data > Limit data using expression > Edit > [Location] = "A"

Assuming you want to display the first 100 Part Number in Location 'A' the expression will be

([Location] = "A") AND ([Part Number]

[abhinandan yavagal]

I am trying to extract data from particular rows