'Group by' Issue

[kundan_sharma1]

Hi,

I have one measure calculated on the basis of 14 dimension.

I want that my output looks like the same as shown in output sheet on the basis of grouping, but when I try to group the them I get the output like the third sheet.

Input sheet is the data extracted from the chart.

Attached file has input as well as output 

[agigliotti]

what's your current script ?

[bhavikumehta]

If you want a Straight table to look same as 'Output' sheet, then no need to use 'Group by'.
Create a Straight table with Field6 as Dimension and sum(Total) under Expression.
Please let me know if it works.

[kundan_sharma1]

Hi Bhavik,

When i take only field6 as dimension then all the values are being considered for sum and the output is shown as on the 3 rd sheet.

Regards,

Kundan S