Add Extra Column After Dynamic Pivot Table

Transact-SQL
21

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

image
image.png1753×987 9.5 KB

22

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

:grinning::grinning:

23

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.

24

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

25

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.