Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am developing one energy management report, My data is like bellow,
| Date | Counter | Shift Nr | Value |
| 01-04-2022 | Item_1 | 1 | 33 |
| 01-04-2022 | Item_1 | 2 | 22 |
| 01-04-2022 | Item_1 | 3 | 33 |
| 01-04-2022 | Item_2 | 1 | 1 |
| 01-04-2022 | Item_2 | 2 | 21 |
| 01-04-2022 | Item_2 | 3 | 23 |
| 01-04-2022 | Item_3 | 1 | 4 |
| 01-04-2022 | Item_3 | 2 | 2 |
| 01-04-2022 | Item_3 | 3 | 5 |
| 01-04-2022 | Item_4 | 1 | 56 |
| 01-04-2022 | Item_4 | 2 | 56 |
| 01-04-2022 | Item_4 | 3 | 3 |
| 01-04-2022 | Item_5 | 1 | 8 |
| 01-04-2022 | Item_5 | 2 | 4 |
| 01-04-2022 | Item_5 | 3 | 43 |
As given in table I will select Date for my report, In given Item List more than 100 counter is there, I want to Add that counter value shift wise and make new table virtually, for example Counter 1,2,3 will make Count_A and Counter 4,5 make Count_B for respective shift number. after this Count A and Count B All shift total value will display As Pie chart and When click on any piece in pie chart, It will display shift wise value of that counter.
I am happy to answer if any additional information required....
