Question:
Hi Gurus, I have a good one here...
My query displays key figures in the columns by period. The totals are displayed in the last column (rigth side).
Requirement: I need to display the totals before a specific date, after the specific date and then the total, everything on the rigth side.
hahaha!, I write this and it makes me laugh...can this be done?
This is an example.
specific date: 200509
----------200508------200509------200510-----Total 1----Total2-----TotalT
Sales-----100---------100-----------300---------200---------300--------500
Answer:
The one you show is easy. Just create a structure.
Column one: select period "spec.date"-1
Column two: select period "spec.date"
Column three: select period "spec.date"+1
Column four: select period <="spec.date"
Column five: select period >"spec.date"
Column sis: don't select period
I assume there are more restrictions to your requirements, as this is straightforward.
What are they?
Leandro
Answer:
Thanks Leandro, and yes: there are more restrictions...
The number of periods is random.
Since I have to display all the periods, I placed the characteristic "periods" above the Key Figures Structure. The structure you proposed would be above "periods" right?. Columns four, five and six would display all the details + results for each selection. These 3 columns should display only results...
Is there anyway to display only results and no details..? for each selection...?
Answer:
Following the same issue...:
When you make a selection within a structure in BEx (excel) you get the calculated results at the end of that selection. If you have two selections within the same structure you get the results after each selection.
Question: How can I do to get all the results at the end of all selections? e.g.:
---Selection A---Selection B---Selection C---Result A---Result B---Result C
Answer:
It cannot be done. However, let me suggest something:
- Create two queries, one with the drill across by period, the other one with the three totals.
- Create a workbook with the two queries
- Put the result area of the total query in column A.
- Put the result area of the drilled across query in column D
Then you'll have this:
----------Total 1----Total2-----TotalT----- 200508------200509------200510
Sales-----200---------300--------500-----------100---------100-----------300
Would that work? Depend on you users...
Truw, you cannot navigate anymore, or the queries will get out of sync. However, this kind of requirement comes from users that don't care about navigating.
Leandro
Answer:
Thanks Leandro.
We did it as you proposed and it worked.
Thanks again.