Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am looking to display all the data that there is, currently when I select a particular DATA(my date field) only then I am able to populate the columns.
For example
I want to see a table like this
DATA | SUM(VALOARE) | SUM(<2 day before> VALOARE) | SUM({<1 day Before>} VALOARE) |
516 | 0 | 0 | |
8/19/2011 | 120 | 0 | 0 |
8/20/2011 | 126 | 0 | 120 |
8/21/2011 | 132 | 120 | 126 |
8/22/2011 | 138 | 126 | 132 |
Instead I am only seeing data when I click on a particular DATA date.
This is what I see when I click on DATA=8//22/2011
DATA | SUM(VALOARE) | SUM(<2 day before> VALOARE) | SUM({<1 day Before>} VALOARE) |
138 | 126 | 132 | |
8/20/2011 | 0 | 126 | 0 |
8/21/2011 | 0 | 0 | 132 |
8/22/2011 | 138 | 0 | 0 |
Thanks for the help in advance.
Ajit
try above( sum( VALOARE), 2 ) and above( sum( VALOARE), 1 )
This is a simplified veiw of the sheet I actually have, using above solves this problem but doesnt work for my other table where there are more complications.
Do you know of a solution using Set Theory ??
Thanks anyways.
Hi,
When we are selecting any date from datanum field the results are showing up correctly.. it might be the case that due some inconsistency of data the results coming yp are not proper... kindly convert your datanum field into date and then see the result..
sorry
I am not sure you got my question, I am able to correctly populate the sheet when I select a particular DATA point. I want to populate the complete sheet. Hypotheticlly if I have 20 DATA points then I want a 20x3 matrix that is completely populated not a 3x3 matrix when I select a DATA point.
Thanks