Looking for guidance to create a Dashboard for quanties of stock, cashflow and other KPIs. I have table of data where:
Column A = Date (ordered, earliest to latest)
Column B = "In" or "Out" (if it's stock received or stock dispatched)
Column C = Product code (e.g. 1, 2, 3, 4, 5)
Column D =...
I have a pivot Table on sheet "summary"
Where the value in C10 in sheet "Data" is zero, the year to be selected on Pivot filter in B2 must be blank , otherwise select highest year
It would be appreciated if some could provide me with code to do this
I'm new to this forum but have spent a lot of time reading through other's posts, which are often very helpful. I haven't found a definitive answer to the following question and hoping you all might be able to provide some guidance. I am pretty new to Power Pivot - thank you in...
I need a vba solution to reverse pivot a pivoted range
There is a simaler question here
But it gives a Power Pivot (I think) solution to this question. But need a VBA method.
I am just going to use...
I have set up a timeline slicer on a pivot for a tool in Office 365. The users use Office 2013 and the pivot behaves exactly the same on both versions: if we put the slicer on today's date, we have the result of all the lines of today.
But we need more than that. In my version, if I double...
I have a table with many rows and columns. Each row represents a course a user still needs to complete. The row will have the user's name, and a bunch of other columns, including a "People.Temporary" column which indicates if the user is a temporary employee. If the user has more than...
I have a pivot table which is taking data from a field which is populated as follows
=IF(VLOOKUP(B90,'Order Download'!A:BP,62,0)="","",VLOOKUP(B90,'Order Download'!A:BP,62,0))
If this lookup returns a value, all good and i get that into the pivot. If it returns blank (which is the same...
We have employee advance and their repayment details in excel.
Each advance having one row with employee no, name, date, advance_amount
Each Receive(Repayment) having one row with Employee no, name, date and repayment_amount
Now we made PIVOT with employee name , sum of...
I am trying to set up a model that will report for the next twelve months. Each month is on a separate worksheet. I need to show salesperson and sales amount in one of the graphs. Given that sales people may or may not achieve a sale in any one month, I thought that using a pivot table...
I'm using Excel for Mac, and am working on my budget. I've created a pivot chart with a slicer for my monthly categories, but would like for the categories with no values for the month selected to be removed from the slicer. I've googled a good bit, and tried unchecking "Hide Items with...
Afternoon kind folks.
I have a pivot table which I want to add a extra subtotal to.
The pivot table shows a list of Business Reports in rows then the columns show the percentage complete by how well its done good/bad/not started etc.
Currently I have to add an extra column on the worksheet...
Trying to updated pivot table filters of different sheets of different workbook, but the getting error message "Run-time error '-2147024809(80070057)' - The PivotTable field name is not valid... "
Need help to resolve the issue and get the code running.
Private Function UPivot(PName As...
Does anyone have any experience of applying formats to pivot table measures conditionally based on their name?
For example, if my measure has a (£) in its name, then apply a currency format, else apply a simple numeric format.
I've done this kind of thing successfully with ordinary pivot...
Hello - thanks in advance for the help.
How do I convert the following "2019-Q3" which is formatted in excel as "General" to a date format so I can run a pivot table and be able to group by the date?
Hello, This is the 1st time I am working with OLAP Cube Pivots. Need help please.
I have a OLAP Cube pivot that has years from 1900 to current year. However it is missing few years in between. I need to be able to select all the years except for the last 15 years (2004 to 2019 needs to be...
I have file that on a monthly basis I dump an extract into. That extract feeds pivot tables on 3 other sheets displaying the information at varying levels of detail.
I already have a VBA to auto refresh the tables when new information is added but I'd really like one that could auto filter the...
I have a worksheet which has approximately 60 entries added to it each day. The worksheet is summarized into pivot tables on another worksheet with a timeline to sort them by dates. I can get this working no problem however with multiple people adding data to the main worksheet my pivot...