Hi Tamizhanban K ,

Pyramid operates on what are known as dimensional models. As such, it takes each field n the data table, extracts the list of unique values from it as a dimension, say  a list of languages or genders. It treats these independently, so that when you place two dimensions on your grid, they are nested and each element in one dimension is related to every element  in the other dimension though related facts. Thus you cannot, by default, create a report where the dimensions are "Side by side" rather than nested.

So we're going to have to bend Pyramid  bit to get what we want. I need to effectively get my max / min gender, language etc and assign it to a common dimension as members, so I can list them as you require.

First step is to create "holding" members that will host the calculation. Choose a dimension with few real members and create calculated members though formulate to match the dimensions you want to display. In my case here, Gender, Country and Manufacturers. We can initialise them to null as a start.

Duplicate this member 3 times and save them named for your other dimensions, in my case country and manufacturer.

For each of the dimensions  concerned we need to make a sorted list of the members. Create a new dynamic list in formulate and drag the standard list block onto the canvas. Populate it with all the elements from that dimension.

Apply a Sort by Value block, choose the measure to sort by, in my case Transaction Count. As this is being hosted in the Channel, I don't want the data filtered by Channel, so choose the ALL option or select all the elements.

Repeat for your other dimensions. Here's the same thing in PQL Script:

Order({AllMembers([Customer Profile].[Gender])},(AllMembers([Channel].[Channel]),[measures].[Data Transaction Count]),desc)

We now need to create our MAX and MIN calculations. In the MAX column, we need to identify the Row and then take the first element of the sorted list for that row / dimension and get is caption. We need to do this for each row, so the best approach is to use a CASE statement. 

We can read this as:

"If the row header is Gender, get the first element of the sorted list of genders and set the calculation to its caption."

"If the row header is Country, get the first element of the sorted list of countries and set the calculation to its caption."

"If the row header is Manufacturer, get the first element of the sorted list of manufacturers and set the calculation to its caption."

Otherwise set to N/A.

We do the same for the MIN calculation, except we use LASTELEMENT instead:

Here's the same in PQL script:

CASE(
    [Channel].[Channel] IS [Channel].[Channel].+[6f3bc771-f2d2-46f8-9e2c-cb557eb75deb], FIRSTELEMENT({[Customer Profile].[Gender].*[f1899463-dd94-4b4e-89a9-37e85a74c6e4]}).CAPTION,
    [Channel].[Channel] IS [Channel].[Channel].+[efa5046c-291e-4787-a1f6-c04d65906cf2], FIRSTELEMENT({[Customers].[Country].*[9567863d-b4a6-4c91-a34f-b67b2d6610a7]}).CAPTION,
    [Channel].[Channel] IS [Channel].[Channel].+[58e78fe3-f62d-40b3-a3f1-37e15ebea24e], FIRSTELEMENT({[Manufacturers].[Manufacturer].*[15f4b7d4-b530-454e-a892-3432a1c4e387]}).CAPTION,
    "N/A"
)

Finally, we can place Channel on Rows of my grid, selecting the custom member we created, and MIN and MAX Measures  on columns. Filtering by Product subcategory we can see the grid change:

Hope that helps.

Ian