requirement on Straight Table

[#1]

hi

i have created a straight table in that based on conditions i have filled colors in fields but my issue is i have to show the data like below image please find the image.is that possible please help me out on this.

Thanks

[Clever_Anjos]

Yes you can

Use  a pivot table and transpose the dimension

So use a background color to change the color

[#3]

here i have field names .please find that image find sample data

Here in my sample data name is Dimension and based on starts and ends i wrote conditions it works fine.now my issue is how to associate field name with this chart

Note: we need to make all the field names into one field

Thanks

[Clever_Anjos]

Not sure what you really need, would you mind prototyping into Excel the final result you need?

[#5]

is that possible to convert field names into filed values with association?

[Clever_Anjos · Accepted solution]

Do you know the $Field expression?

Put this into a pivot table, please

[#7]

assume ..Anjos.now i need to remove some fields from it .is that possible?

[#8]

Assume...Anjos it is working but i need to remove some field names from it.Is that possible?

[Clever_Anjos]

Use If( Index('City, Country', $Field), $Field)

and put into that list the names you need/want

[Clever_Anjos]

And check "Supress When Value is Null "