I found my solution... Here is the formula I am using which returns the desired value:
=IFERROR(IF(AND(SUMIFS(TABLEAbsence[[Catégorie d''absence]:[Catégorie d''absence]],TABLEAbsence[[Nom]:[Nom]],Calcul!$E40,TABLEAbsence[[Date de début]:[Date de début]],"<="&AX$3,TABLEAbsence[[Date de...
Hello,
I am using Chandoo's vacation tracker, which I am modifying to suit the needs of the organization I work in. So far, I've been able to do what I need however I've run into a problem that I'm not sure how to solve.
I am in the Calculations sheet of the vacation tracker and have modified...
Thanks Chihiro for the quick response. I have upwards of 50 pivot tables. You're saying I should create 50 extra sheets? I have my reports in a few other sheets that are fed from the information contained in these pivot tables.
Hello,
I have generated multiple pivot tables from PowerPivot and am now getting the error message that some are overlapping.
Besides putting 100 rows and columns between each pivot table, does anyone have any suggestions as to the best way to arrange pivot tables in the worksheet in the most...
Hello,
I have an Access database which contains numerous tables with differing types of information. I use this information to generate pivot tables within Excel using PowerPivot.
I'm quite new to Pivot Tables and PowerPivot so without knowing what I was doing, I created a different...
I've been trying to make a formula which says something like:
If Mondays time > 7.5 then
Mondays time = 7.5 AND Tuesdays time = Tuesdays time + (Mondays time - 7.5)
Else
Mondays time stays as is
End if
The Excel formula looks like this: =IF(AO15>7.5,7.5+(AP15=(AO15-7.5)),AO15)
The...
Hello,
I am creating a time sheet for my team in which each team member will enter the number of productions they have in a day. This production amount will calculate into the number of hours worked. For example:
Sam works:
Day M T W T F
Prod. 30 34 12 75...
Hello,
I have a small time sheet for our users. A specific time code has to be totaled separately from the others.
Here is an example of what the sheet could look like:
M T W T F
TC1 1 3 4 2 1
TC4 2 1 3 2 1
TC5 3 2 3...
Hello Everyone,
At work, I have a list of time codes I have to charge my time to. Thanks to Chandoo.org, I have been able to build myself a nifty dashboard using pivot tables and graphs which helps me greatly when completing my time sheet.
I do have one problem left which I have no idea how to...
Hello all,
I have generated a pivot table which includes data from this year and last year as below. This data can be filtered by item type.
What I would like to do is add a calculated field depicting a prediction of how many items I will receive in a given week: (In / Sum of In) * X (ex...
Thanks @Chihiro, the two websites' contents look very promising. I use quite a lot of VBA, but I wanted to be sure that there wasn't something simple that could be done to fix my problem.
You're very helpful.
Hello all,
I am trying to highlight a pivot table row to draw attention to the current week.
My formula works correctly to highlight the current week, however every time the table is updated or if I apply a filter, I lose the formatting on all cells except the first cell in the row.
Can...
Thanks Chihiro for the answer.
I am already using weekly level for comparison, as that is all I have access to. I don't have any daily statistics, so I won't be able to compare patterns within the week.
Hello all,
Here's my situation: I have team data to analyze for two years. This year's report is updated weekly - last year's report is used to compare and predict what will happen this year.
This data is displayed by week (date of ending Friday). Because the dates don't exactly match from...
Hi Luke,
Thanks for the information. I knew I could refresh the PTs with VBA, but I wanted to know if there was any other way. I had done some previous searches online but didn't come across anything conclusive. I can usually find the missing pièces here though, that's why I asked.
I am quite...
Hi Luke,
I've been playing around with the PivotTables of the PivotTables and have noticed that they don't update automatically. Is there any way to get them to? I've been trying to emulate what Chandoo does is his dashboards by using segments, but the charts don't seem to update when I make...
A redesign may be possible, however I don't see how I could do it.
This information is being scraped from a database, which I am dumping into Excel. I was not aware that we can do a pivot table with a pivot table, so I will investigate that closely. Thanks for your help.
Hi Luke,
Thanks for the quick response!! I was able to reproduce what you are doing, and I did get the same results. Your response also allowed me to see what my problem is, perhaps you can give me a solution for this as well:
My data is not set up as straight-forward as your's. See my screen...
Hello all,
I have a pivot table pie chart to display team scores. I want to display only data with values which are greater than zero.
I have selected to display values as well as categories in the label options. I have used the custom number format #;; to hide the number values, but this does...