Forum Discussion
Solved
Pivot Table with Multiple Dates
Hello guys...hoping you can help me here. I want to create a pivot table where I can see at once the current number of man-days the worker has consumed. The workers are on-call, hence there are so m...
Creating PivotTable add data to data model
Add Name to Rows.
In PivotTable pane right click on table name and Add measure
add measures one by one
Finalize PivotTable with them
Thanks Sergei.
This is the output I want to have.
But I don't know how to use your formula.
I am using Excel 365.
Creating PivotTable add data to data model
Add Name to Rows.
In PivotTable pane right click on table name and Add measure
add measures one by one
Finalize PivotTable with them
- Thanks again. I'm almost there!
2 Things!
1. MIN of ARRIVAL does not show
2. There is a 3rd option on the STATUS. A Worker is ON LEAVE if he just termporarily left for R&R. I cannot add it in the formula because it says maximum of 3 arguments only.
Please help.Arrival shows MIN ARRIVAl date
Didn't catch how ON LEAVE shall work, it's just possible latest status together with Active or not. Perhaps
Current Status:=VAR statuses=VALUES(daysConsumed[STATUS]) RETURN IF("On leave" IN statuses, "On leave", IF( "Active" IN statuses, "Active", "Inactive" ) )If you generate small sample file with possible cases is source and desired answer it'll be easier to check the logic.