• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pic Button for Toggle Row Labels to filter

Dear All,

Any possible way to toggle pivot with Report filter to Row Labels.
I.e. PFA.

  • "Row Labels" - "Names"
  • "Report filter" - "July"
  1. Now I when i click the image in that sheet.
  2. Pivot should Toggle like
  • "Row Labels" - "July"
  • "Report filter" - "Names"
Please Help!!
 

Attachments

  • PIC Button for Pivot exchange.xlsx
    14.6 KB · Views: 8
Hi Lakshmi Narain,

As always there are n number of solutions for every problem.
try one of these:

1. This can be done with macros.
2. "Visual Cheat Method" - Create two PTs in two different sheets. one sheet with PT Names and Month and other sheet with PT Month and Names. And at same position place the image. Use hyperlink on the image to navigate between two sheets.

Note: You may have to keep the data in separate sheet so that you dont have to duplicate data/efforts. And also to refresh PT, use ctrl+alt+F5, this will refresh all the PT in the workbook at one shot.

Regards,
Prasad DN
 
Hi Lakshmi Narain,

As always there are n number of solutions for every problem.
try one of these:

1. This can be done with macros.
2. "Visual Cheat Method" - Create two PTs in two different sheets. one sheet with PT Names and Month and other sheet with PT Month and Names. And at same position place the image. Use hyperlink on the image to navigate between two sheets.

Note: You may have to keep the data in separate sheet so that you dont have to duplicate data/efforts. And also to refresh PT, use ctrl+alt+F5, this will refresh all the PT in the workbook at one shot.

Regards,
Prasad DN
But My task that given from my manager it should be in single sheet.
 
Dear All,

I find one solution but i want to toggle it.
Code:
Option Explicit

Sub Picture1_Click()
    Range("Q6").Select
    With ActiveSheet.PivotTables("PivotTable2").PivotFields("July")
        .Orientation = xlRowField
        .Position = 2
    End With
    With ActiveSheet.PivotTables("PivotTable2").PivotFields("Name")
        .Orientation = xlPageField
        .Position = 2
    End With
End Sub
But i want to make it toggle
 
Back
Top