Hi,
my requirement is that i have to different Hierarchies Balance sheet and income statement.
and a query for each if these and these 2 are embedded into a work book. when i refresh the workbook the variable window pops up and since the varaible is same for both it pops up only once for the entire workbook and i get to select only balance sheet or income statement and teh other comes up with no data.
if i select income statement balance sheet has no data and vice versa.
how do i resolve this
i am not sure if i was clear in explaining my problem.
let me know if its not clear