Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you know the $Field expression?
Put this into a pivot table, please
Yes you can
Use a pivot table and transpose the dimension
So use a background color to change the color
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
Not sure what you really need, would you mind prototyping into Excel the final result you need?
is that possible to convert field names into filed values with association?
Do you know the $Field expression?
Put this into a pivot table, please
assume ..Anjos.now i need to remove some fields from it .is that possible?
Assume...Anjos it is working but i need to remove some field names from it.Is that possible?
Use If( Index('City, Country', $Field), $Field)
and put into that list the names you need/want
And check "Supress When Value is Null "