Add Extra Column After Dynamic Pivot Table

hi jacky

I tried to understand this

I think the problem is with the query
I mean
removing columns in blue will do the trick

removing columns in blue

Hi I think this link will help understand how to do

Maybe somebody can interact with you should resolve very quickly
Lot of experts on this forum..


hello @harishgg1,
sorry for late reply. actually i think removing the query in Blue box that you mention will not solve the problem. I alse Need that record to be show in the query result.

thank you @harishgg1, i will try it :grin::grin:

hello @jeffw8713,
sorry for late reply. if T1 Value for 2019-03-21 is NULL then i want it to be 0,
So we still can COUNT the usage.