Hello everyone,
I would like to share this scenario to you all.
I have a query with structure in column, 0country and local currency in rows. The query design preview, shows country and local currency in different columns.
0country has hierarchy.
When I execture the query local currency values are suppressed with country hierarchy nodes. Or local currency is not populated separately in a column.
Please share your ideas.
Thanks