Forum Discussion

Niraj_vora0106's avatar
Niraj_vora0106
Helper III
4 years ago
Solved

Drill-Through

Hi, community

I have a doubt relating to Drill-through.

Like I've CY and PY Order Quantity category-wise. 

I've added both PY and CY columns in the Details page too and applied Drill-through which works perfectly with the Details page. 

 

All I wanna know and ask is,

For eg:  If I right-click or use the Drill-through button on the PY Order Quantity of Bikes category (Dark Yellow Color),  is it possible to see only the PY order quantity? and Not CY order quantity on the details page? 

I've to use both the columns on the Details page, but while Drill-throughing if I'm clicking only on PY then it should only show the PY column instead of both columns.

And same goes for CY, if I'm clicking only on CY then it should only show the CY column instead of both columns.

 

Is it possible??

Need Help
  • Pragati11's avatar
    Pragati11
    4 years ago

    HI Niraj_vora0106 ,

     

    No this is not possible, keeping your CY  and PY column on the same table.

    I would suggest create 2 different drill-through pages: 

    • one for CY
    • one for PY

    Thanks,

    Pragati

6 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    Hi Niraj_vora0106 ,

     

    If I am understanding right your drill-trough detailed page is created just in Category column.

    What you can do is, go to your drill-through page and enable Keep all filters option:

    See if this works.

     

    Thanks,

    Pragati

    • Niraj_vora0106's avatar
      Niraj_vora0106
      Helper III
      4 years ago

      Hi, Pragati

      Firstly, Thank you for replying 

      I've kept "Keep all filters active"

      Yes, the Drill-through detailed page is created in the Category column but it is also based on another Application column and the table contains multiple columns, as all types of visuals are linked to the Detailed page as it is a whole detailed page of all pages.

       

      Otherwise, Drill-through works perfectly only not able to show that particular PY or CY column or field you can say.

       

       

      • Pragati11's avatar
        Pragati11
        Super User
        4 years ago

        Hi Niraj_vora0106 ,

         

        Can you add some svreenshots here for me please?

        It's hard to understand what all you have on the source page and what all is on Drill-through page.

        Also what you really want.

         

        Thanks,

        Pragati