hierarchy with subquery

Itamar Steinberg shared this question ago

Answered

How can I drill down on a field with hierarchy when the report in constructed out of subquery?

for example:

sales vs target.

the target is in a different view.

on the yyyy-mm level with a hierarchy field of yyyy -> yyyy_mm

the outcome is:

date (hierarchy), sales, target

now, I want to see the data first by year and then by yyyy-mm (the hierarchy)

I have tried to do it both on the join between the two queries and with link_to filter

Any suggestions?

thanks

The same question

Replies (4)

Guest ●

Hi Itamar,

if I have understood the scenario correctly, it sounds to me like perhaps the best thing here would be to use composite views. Normally we don't really recommend the Composite View functionality much these days as we regard the Advanced Sub-Query as the superior functionality, however in this situation it seems to me that it would definitely be worth a try. Unfortunately I am almost at the end of my working day here so I can't set up the tables, data and views etc. to test it out. However, as I said, this is certainly a suggestion worth trying.

regards,

David

Reply URL

Guest ●

Hi Itamar,

just cleaning up my worklist and I noticed that this ticket has been in the "Awaiting Reply" status for 3 weeks now, so I'm just inquiring now whether you consider it completed or not?

regards,

David

Reply URL

Itamar Steinberg ●

hi,

you can close it..

thanks

itamar

On Mon, Jul 31, 2017 at 9:29 AM, Yellowfin Support wrote:

Reply URL

Guest ●

OK, thanks Itamar.

regards

David

Reply URL