I am building a workbook using a single query, with same navigational structure. The workbook contains 2 sheets, each with same query output, but differing in units. Worksheet 1 uses unit A for quantity whereas worksheet 2 uses unit B for quantity, which is the requirement from users.
I have built a WB and I have observed a strange behaviour, when I am refreshing the workbook it is giving for only one unit, say A in both sheets.
I have unchecked "Display duplicate variable only once" in the workbook properties, so that I can enter variable inputs separately.
Could anyone help me in understanding the behaviour of workbook. Please let me know, if am not clear in my information.
Thanks and regards,