SQLTeam.com | Weblogs | Forums

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 live....it 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.