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
latest status 2023/6/15？
| Worker 1 | 2023/6/15 | Active | 130 | |
| Worker 2 | 2023/1/20 | Active | 100 | |
| Worker 3 | 2023/1/20 | 2023/1/31 | Inactive | 5 |
create temp table aa as
select f01,f02,f03,f04,sum(f05) total,max(f02) m from showing_the_latest_Status group by f01;
cli_no_header;
select colExclude[m] from aa;