Using location twice in data model but want to show it once in pivot table

[rarora12]

Thanks for the assistance in advance!!

I have to use a location table twice in the data model.  Once related to an expression between 2 dates and then again in a master calendar with specific dates.

One a chart , pivot table - the user only wants to see the location and all the totals - the user doesn't want to have 2 pivot tables.

I am kind of stumped and don't know how to proceed?

Rick

[swuehl]

Not sure if I understand your setting.

Could you post a small sample QVW (best!) or some screenshots of your data model and UI etc?

[avinashelite]

Hi Rick,

Please share the sample data and the desired output format so that it will helpful for us to suggest a solution