If you are using a Matrix grid then you can simply use the Formatting panel to format the member in the rows / columns. In the following example I want to format the manufacturer ‘Adihash’ in the rows areas of the grid.

Select the element in the rows and select the Formatting panel > Rows option. Change the background colour.

The Manufacturer > Adihash element will be formatted wherever the element is displayed.

 

 

 

If the data is displayed using a Tabular grid option the formatting panel > rows option is not available. In this example we create a measure (Formulate > Calculation) and use it to format the row background colour.

 

 

In the this example I have created a parameter (Global) to allow the end user to control which manufacturer element to colour based on the characters the manufacturer description starts with.

Create a global parameter, type : text with input validation as shown below.

 

 

Using Formulate > Calculation I then create a measure based on the relevant data model.

Calculation:

 

If (StartsWith(<dimension/attribute>.currentmember.caption, <text>), RGB (221,86,49>, RGB (256, 256, 256))

-          <dimension/attribute>currentmember.caption – read the current row manufacturer element description

-          <text> - select Global parameter

-          RGB(221,86,49) = orange

-          RGB(256,256,256) = white

 

 

In the Dropzone > Color area place the Measure Color element in the ‘Value’ area.

You can find this solution and many more in the Pyramid Knowledge Base.