View data in Bar Gauge

I`ve got this query:

FROM [myserver].[dbo].[mydatabase]
WHERE [CNT] > 650000
If i switch to a table view i can see the 2 columns like this

I want to use the first column’s row values of the query (PID) as the series’s names for my Bar Gauge and use the 2nd column values (CNT) as the value for each series. Bot my result is next

I have got 12 columns, but not 6 !! WHY??? my data is duplicated. i dont understand…
About type $__cell_0 i know, but it dont work.

Please, help