My client has given me data structure as such, in excel form:
If I took out the "Total column" and leave the data as y1 until y5, how can i write an expression to sum up y1-y5 , with data in such format?
YOu can write the expression like this
total =Sum(y1) + Sum(y2) + Sum(y3) + Sum(y4) + Sum(y5)
if it is dynamic number of columns can you share the sample data?
hello Jagan, the data is static data. i will try the method u posted. thank you Jagan.!
If the columns are static you can directly sum up all the columns, if not then you have to use CrossTable().
You can transpose the data and then use sum(), or use RangeSum(y1,y2,y3,y4,y5). Check Crosstable in the help file as well.
HI there, Thanks for your advise!
You Can use Pivot Table with Slicing/Dicing Features for same
you can use cross table and check
Retrieving data ...