I'm an intern needing to pull a report for someone on our sales team. My supervisor is on vacation and I'm not very familiar with BEx. I also work for a small company so there's no one else here who knows BEx other than my supervisor.
Basically, this person is asking for me to make a query that has 3 different date variables (07/2014-12/2014, 1/2015-12/2015 and 01/2016-06/2016) in order to see how sales have trended based on those periods. However, when I try to input multiple date variables, it won't allow me to. I've tried separating each date with a ";" and then a space but it just ends up pulling the data for only the first date in the list. My question is, can I have a report with multiple values in the "Month/Year" variable box? Or is it not possible?
I've been to the "selecting variable" help page and searched this forum for an answer but can't find one. I read somewhere to hold down the shift key and somewhere else to hold down the ctrl key. I've tried both and neither have worked (unless I'm somehow doing it wrong). Please share any knowledge or advice if you think it would help me!
Request clarification before answering.
Hello Emily,
Try to create 3 Restricted Key figures and restrict them with different variables. You can use them in your column structure. Make sure you don't restrict the same characteristic in the Filter section, otherwise your result set will be incomplete.
Thanks
Francis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.