Wednesday, July 8, 2009

Filter multiple rows using Flitered rows property

This visalization shows how to filter multiple rows, here i want to filter data based on the Plant and Year, however if i use Filter component i can get only 1 row in the destination....so here i used 2 Combo Box components with filtered rows as insertion type...

Data:
Plant, Year, Matrerial ,Expiry Stock
Plant A, 2007, Mat 001, 1324
Plant B, 2007, Mat 001, 892
Plant A, 2007, Mat 002, 1562
Plant B, 2008, Mat 001, 1893
Plant A, 2008, Mat 001, 1387
Plant B, 2008,Mat 002, 2333
Plant A, 2008, Mat 002, 2721
Plant B, 2009, Mat 001, 992
Plant A, 2009, Mat 001, 1452
Plant C, 2009, Mat 001, 1734
Plant A, 2009, Mat 002, 2276
Plant C, 2009, Mat 002, 1888



To view the thread, visit: SCN -Xcelsius Forum
You can download the source file from here
Posted by at

5 comments:

  1. Sushil KumarMarch 1, 2010 at 12:58 AM

    Hi Anil,

    I am trying to prepare a similar type of chart but the problem here is that my x axis is different.for eg, my data is
    1 filter i have Regions(APJ, EMEA, LA, CEMA)
    2 filter i have countries(India, China, Japan,)
    my X axis i have vendors which are different for dirrent countries.
    how do i plot the chart and arrange the data.

    Regards,
    Sushil

    ReplyDelete
  2. AnonymousJanuary 28, 2011 at 12:15 PM

    Hi Anil,

    Thanks for the useful post! I have a question about the destination cells

    For the first destination, why are there 4 rows even though there is only the option of Plant A,B,&C? Shouldn't there only be 3 rows?

    Same question for second destination. Why are there 4 rows if there is only an option of 2 years and only 2 materials shown?

    Thanks!
    Pari

    ReplyDelete
  3. SwadeepMay 19, 2011 at 10:23 AM

    Can we have 2 series in such kind of scenarios?

    ReplyDelete
  4. HvacserviceApril 4, 2012 at 5:19 AM

    It is an informative blog about filter multiple rows using flitered rows property..thanks for sharing it ,this will prove worthwhile in my business.. Air Conditioning Baltimore ...we provide the best air conditioning services in Baltimore..

    ReplyDelete
  5. AlejoMay 24, 2012 at 8:32 AM

    Supose I have 2 tables. The first one is the one you have up there (Plant, Year, Matrerial ,Expiry Stock).

    And the second one has the same columns and it's filtered.

    For example: I have a RadioButton/ComboBox with Plant A, Plant B, Plant C, and the result of appling filtered row goes to the second table.

    How can I do to add a 4th option like "All" that sends to the second table the result of appling no filter???

    I don't know if I'm clear enought.

    Thanks!

    ReplyDelete

Subscribe to: Post Comments (Atom)