Slicer

[kme]

Question

1. Need to Make a Slicer from Answer Sheet Table By Month Wise, Above Table Came form another Sheet through formula

2.Sample Dummy Slicer Given In D20 Same like Required

3. If We Click "Apr" Button Only Apr Data Came In D25

4. If any Data Edit In Data Sheets Then Auto Update In Slicer Linked Table

 

[kme]

Please can any one to Solve this

 

[AlanSidman]

Your issue is and will probably be an ongoing one in that your data is not normalized.

Suggest you re-arrange your data with seven columns

Division

Month

Sales

GP

GP%

2SALESC

GPC

Once your data is in this format, you can then run different analysis, filters and slicers without too much issue.
While your current layout is great for presentation it makes the analysis very difficult.

 

[AlanSidman]

I have transformed your data to a normalized table using Power Query and then added a slicer. To change the slicer to horizontal. Click on the slicer and change the number of column in the slicer options to 5 or however many months you wish to show.

 

[kme]

Sir , We Need Data Based On Employee name .

Employee name Can Select Drop down list in "D4".

Below mentioned Table Excel "Table" Sheet There is D7 no Header Due to There is a formula if Can Re-arrange formula for Came D7 header

 

[AlanSidman]

Since the data provided by you only contains one name, why is this even necessary. If it is to be filtered by name, then perhaps it would be prudent to supply a sample that showed multiple names for filtering. Additionally, this was not part of your requirements shown in M19:23

 

[kme]

While Using Power Query and Pivot There is no Auto Update !. if Change Any figure In Data Sheet!. If So We used a formula "Table" D6 Due to Data Summarize

1.We try to make Header In Column D7 .But Unfortunately Not Came !.if Can Re-arrange formula for Came D7 header

 

[vletm]

kme​

Did You duplicate one of Your previous thread?

Find Formula Required And Slicer

Here Attach Jan Feb and May Data While Selecting Employee Name There is Division Details Automatic Came through excel formula Slicer Needed Month Wise Sales A new data sheet will be added every time the same month is complete. Answer Required in Sheet "Answer" Sample Answer Data also...

chandoo.org

Here ... same my sent file with slicers.

 

[AlanSidman]

While Using Power Query and Pivot There is no Auto Update !.

This is not a true statement. If you update the source data and then on the Data Tab, select Refresh All (Same Same as if you had a regular Pivot Table) then the output updates. If you want it automatically, then on the data Tab, select Queries and Connections and then click on connections and select update upon opening spreadsheet.