Hi,
I have below data in lookup,i need to add up the row data
example: For first row i need to add total offw,total 'B',total 'V' and show the count in 3 different column for OFF,B and V.
Similary for each row i need add the same data value and show in a column
any query or commands ?
| rename count(FieldValue) as count
| table Names FieldValue count
| xyseries Names FieldValue count
Assuming you can't get to the data before it has been put in this format, you could try untable to reverse the xyseries, then count the various values by whatever that first column is.
@ITWhisperer Thank You.I got it in below format using the untable command.
How can i get in the below format.
Names | A | B | C |
XYZ | 11 | 4 | 7 |
|
|
|
|
| rename count(FieldValue) as count
| table Names FieldValue count
| xyseries Names FieldValue count