Summarizing numeric fields from a row, in one single field

[npadilla73]

Hi,

I created a pivot table, with 5 dimention, but I need to sum several columns, depend of my search the number of columns.

In this moment, the requirement is summarize row by row, given the columns.

I have added a Calculated Dimention in my pivot table, but I do not know how to use the sentence For.

Somebody can Help me out.

Thanks

[swuehl]

Could you describe your setting a bit more detailed? Best by uploadin a small sample QVW to this thread.

If you want to sum some numeric values, you can look into rangesum() function, e.g. to sum columns 1 and two in a chart:

=rangesum( column(1), column(2) )

[npadilla73]

Thanks for your answer,

That's exactly what I did, "= RangeSum(Column(1), Column(2))" in a Calculated Dimension field. But only show me a cero values. It's important to mention, some field in my expretion are null.

[swuehl]

I believe that should go into an expression, not calculated dimension.

To help you more, you need to explain what you are trying to achieve a bit more detailed. Best by creating and uploading a small sample QVW.

[npadilla73]

I will work on it, give me some minutes.  For the moment, I send you an image, how my pivot table visualizes my data.

[swuehl]

Are you looking for a partial sum for dimension Day?

You can enable this in presentation tab of pivot chart properties.

[npadilla73]

In the column SumRow (It is a calculated dimension), I need to sum all the colums, per row, but It depends of the numbers of days.

It's ok, The partial sum per column, but I need it per row too, and that's where I am stuck,

[MarcoWedel · Accepted solution]

in the presentation tab of the chart properties mark your "day" dimension and check the "show partial sums" check box.

hope this helps

regards

Marco

[npadilla73]

Thanks Marco, that's what I need.   I did not understand to swuehl at the begining, but I think he tried to explaining what you wrote.

Thanks again.