summig of column values

[#1]

Hi,

I am attaching the sample app along with the requirement. Please need an quick suggesionts on this.

[#2]

Hi,

May be like this. Please find attached.

Thanks,

Chiru

[#3]

Thanks Chiranjeevi,

the solution is not upto the requirement

[#4]

Move dimesions to expressions.

[#5]

thnaks Navdeep for the response

that doesnt work

[#6]

Then tell me what you want exactly

Thanks,

Chiru

[#7]

i need to combine the identical values

like  sales values like 200, 200 for Sales ID S01 we need to have S01: 400 value

[#8]

bump

[#9]

Hi there,

I think there are two ways to approach this.

1. First is you could create a Pivot Table with SalesID as your dimension and create an expression of Sum(SalesCount), you will get your desired output.

2. If you wish to show all the columns present in the excel then you could select all the dimensions then create two expressions:

-> Aggr(Sum(SalesCount),SalesID)

->Sum(SalesCount)

The second expression is required so that you could show all the values else only one row of sales and other fields will be displayed.

You could then apply formatting to the second expression so as to hide it.

Attaching the file.Hope it helps.