issue with sum .. no data shows .. sample included

[amien]

1. shows the ordinary data

2. shows the same data only the values are capped until main value. This included a filenumber level.

3. now i need the same, but only without the filenumbers. so only the batchlevel and date. Now the pivot is empty..

[amien]

uploaded now..

[amien]

/bump

[amien]

is it really that hard? do i need AGGR()?

[#5]

Hi,

In pivot 3 just delete the existing expression you have in there. Add new expression Sum(payment) .....I think thats it if I am understanding your question correctly.

Alan

[amien]

nope .. in number 2 i have a horizontal total running .. using rangsum and before. .. based on a filenumber,date level.

now i want to remove the filenumber dimension and sum the payments by date .. that sum should be based on the values that i see in pivot number 2.

so.... i have a batch,filenumber and date in dimension .. and some calculation in expression.. the data that i see in that pivot, should be aggr by batch/vertical summed.

Sum within a calculated expression