#pivottable #pivot

My Formula Problem this above condition , Not show Proper Format We Need this Format Result : EXP/025/21-22 Kindly Correction Below Formula , and Show Perfect Formula in this case =LEFT("EXP",3)&"/"&MID(A2,5,3)&"/21-22" Help me !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference

How to Match workbook to other workbook data & Get status (HOW To MATCH "BOOK2" WITH "BOOK1" , All data Match , to Get Status and Highlight 4 CELL matching How it possible ???

Can a pivot table calculate two items under one category? Here's an example of what I want to do. I've provided a table of what I want the pivot table to look like when it's calculating the data. I don't know how to add/include actual excel cells into my message so I apologize about that...

Hi I need some help setting up a pivot table. I need to compare sales figures from 2 seperate years for example sales figures from week 1 2016 against sales figures for week 1 2017 for each store. I then need to be able to show the monetary difference between each year and the % difference...

Hello, I am working with a fairly large dataset with ~120 Columns and 10,600 rows that I need to make pivot table ready. However, I am not sure how to approach this given the layout of the data output as is (Please see image https://imgur.com/k3XA1T5) Your help would be much appreciated! Thanks!