How to represent two fields values in row wise and one field value column wise in Splunk table?

[spkriyaz]

HI,

I am trying to recreate the same structure in Splunk which was created in excel. I have five fields week, total transactions, codes, count of codes and code percentage.

Sample data are shown below the first two column in blue should be represented in row wise and next three column in orange should be represented in column wise in Splunk table.

 

I want to display the week and total transaction in row wise followed by column codes showing the count and percentage of it in column wise for each code like below.

Please let me know if it is possible?

Thanks

[ITWhisperer]

This is not possible with the standard table visualisation