Skip to Content
author's profile photo Former Member
Former Member

plant and month wise filter

PlantName[Code] Jan_IS Feb_IS Mar_IS Apr_IS May_IS Jun_IS July_IS Aug_IS Sep_IS Oct_IS Nov_IS Dec_IS GOA STORES [140] 0.036516679 0.0076719 0.0132713 0.0166431 0 0.0477271 0.0127925 0 0.0378513 0 0 0 WAGHOLI STORES [150] 10.94680396 2.4411534 0.0017998 3.8701599 0.4574391 5.7896103 0.1366737 0.0026649 0.0364306 0 0 0 WADI STORES , NAGPUR [160] 0.377276675 0.1634367 0.0927132 0.0621517 0.194051 0.3962933 0.3163944 0.1846593 0.1696565 0 0 0 SINGARAULI STORES [225] 0.122423018 0.1544609 0.0856866 0.0352031 0.2667669 0 0.6498731 0 0 0 0 0

with these data I have to show Plant wise and month wise filter, is that possible with this data?

ie:) if I select 1 plant and month the data should show in gauge meter,

2 filter 1.plant 2.month output value in gauge meter

is that possible with these data? if so how to do that? please help me out

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 25, 2013 at 04:15 PM


    Use Insertion type row for the Plant filter - map the labels to all plant names, source to all the columns but excluding header.

    In the destination area add th eheader harcoding if you always get same value or simply add a formula equating to the original headers.

    Then use the Month filter with column insertion type - Labels mapped to month names in the above destination area and and source to all the month columns and destination to a cell.

    Map the guage to the final cell..



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 25, 2013 at 09:35 AM

    a sample xlf file is attached. unzip the file and change the extension of the txt file to xlf.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Russel,

      In an another post, you have mentioned that you are mapping the month values to a column chart with a plant value in selector. Then you can give drill down from chart to the gauage. ie you can enable drill down in chart and pass the value corresponding to each month to the gauge meter.

      Hope it helps


      Nikhil Joy

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.