Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
#1 Posted : Wednesday, January 24, 2018 6:20:23 AM(UTC)
Rank: Newbie

Groups: extranet\Forum
Joined: 10/13/2017(UTC)
Posts: 2

Hello Experts,

I have an analysis (Line Graph) having Inventory Values in y-axis and As of Dates (Period) on x-axis , and I have added comparison by Location(Which includes 4 locations).
So My question is : Can I add these comparisons in Criteria Bar so that I can select the two locations.
I tried By adding Location Code Dimension in criteria bar But its not working.
please help me ASAP its very urgent.
Thanks in advance.

#2 Posted : Wednesday, January 24, 2018 7:50:13 AM(UTC)
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 514

Hi Manita,

I am afraid you cannot do that. One reason is the cardinality of the criteria involved. Once you have added a comparison to the the line chart, the criteria in the comparison elements will be stronger than any criteria you would like to add from the criteria bar (from the same dimension/comparison). I.e., even if you could select two locations, the line chart would still show all four locations.

I can only think of 'drag-and-drop comparisons' as something that might come close to the desired result: Create your line chart with Inventory Values and Period, but without the comparison. Create another object, a crosstab, with Inventory Value and the comparison with the four locations. Now, drag the elements you want to compare from the crosstab to the linechart. Notice, this will only work in the Windows client.

BR / Ole

Ole Dyring
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.