Always append data at the end regardless of what filter is set on UI

[#1]

This is how my table look like. I always have to show the data where StatusChanged field is set to 'Changed'. How do i achieve that?

I am showing Month/Year List box on the UI but i always want to show the rows that has StatusChanged to 'Changed' even if they fall outside the filter and if they fall outside the filter, change the ItemCategory to HasStatusChange.

TABLE:

LOAD *

INLINE [

    ItemType,          ItemCategory,     ItemName, StatusChanged, AddedOn

    ItemType1    ,    ItemCat1        ,    Item1,         'Changed',        '01/01/2015'

    ItemType1    ,    ItemCat1        ,    Item2,         'Not Changed', '04/01/2015'

    ItemType1    ,    ItemCat2        ,    Item3,         'Changed',        '01/05/2015'

    ItemType2    ,    ItemCat1        ,    Item4,         'Changed',        '08/04/2015'

    ItemType2    ,    ItemCat2        ,    Item5,         'Not Changed', '10/01/2015'

    ItemType2    ,    ItemCat2        ,    Item6,         'Not Changed', '12/01/2015'

    ItemType3    ,    ItemCat1        ,    Item7,         'Changed',        '05/04/2015'

    ItemType3    ,    ItemCat2        ,    Item8,         'Changed',        '07/08/2015'

    ItemType3    ,    ItemCat1        ,    Item9,         'Not Changed', '01/01/2015'

];

[fred_s]

Hi Sal,

See attachment.

Fourth dimension is

=if(StatusChanged = 'Changed', StatusChanged, null())

Grtz Fred

[#3]

May be i did not explain properly.

if an item has status changed and user has selected January in the filter box, i want to show all the items that were added in January and the ones that has StatusChanged = 'Changed' regardless of when they were added.

In short, it should always show the records that has StatusChanged = 'Changed'

[awqvuserneo]

Hi Sal,

Are you expecting the result look like this when 1/1/2015 & 1/5/2015 are selected?

AddedOn	ItemCategory	ItemName	ItemType	StatusChanged
01/01/2015	ItemCat1	Item1	ItemType1	Changed
01/01/2015	ItemCat1	Item9	ItemType3	Not Changed
01/05/2015	ItemCat2	Item3	ItemType1	Changed
05/04/2015	ItemCat1	Item7	ItemType3	Changed
07/08/2015	ItemCat2	Item8	ItemType3	Changed
08/04/2015	ItemCat1	Item4	ItemType2	Changed

OR

AddedOn	ItemCategory	ItemName	ItemType	StatusChanged
01/01/2015	ItemCat1	Item1	ItemType1	Changed
01/05/2015	ItemCat2	Item3	ItemType1	Changed
05/04/2015	ItemCat1	Item7	ItemType3	Changed
07/08/2015	ItemCat2	Item8	ItemType3	Changed
08/04/2015	ItemCat1	Item4	ItemType2	Changed

[#5]

Yes. The first set is what i am looking for. Is it possible to change the ItemCategory to 'StatusChanged' if the rows fall outside the filter? If you select January then something like this

01/01/2015	ItemCat1	Item1	ItemType1	Changed
01/01/2015	ItemCat1	Item9	ItemType3	Not Changed
01/05/2015	ItemCat2	Item3	ItemType1	Changed
05/04/2015	StatusChanged	Item7	ItemType3	Changed
07/08/2015	StatusChanged	Item8	ItemType3	Changed
08/04/2015	StatusChanged	Item4	ItemType2	Changed