Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a application where are two pivot table charts and some calender selection objects are there like Year, Month, Quarter, Current Week, Yesterday, Sales manager, Manager. I have a query that if i select some calender selection like Year, Month, Current Week, Yesterday, Quarter then it will reflect only single pivot table and data should change according to data but another pivot table chart will unchange when i select Year, Month, Quarter, Current Week, Yesterday. Also when i select Sales manager, Manager it will change. Please provide help for that.
Anand
Use a set analysis to "modify" the selection the graph think it is.
Example:
Let's say the graph that changes when a calendar dimension is selected have the following expression
=sum(Sales)
then, in the graph that has no change on "Year", "Month", "Day", "XXX" dimensions, you should have the following expression instead
=sum({$ <Year=, Month=, Day=, XXX=>} Sales)
Hi,
Thanks for this but i have a current selection type of filed which has occupy two types of data like
Current Selection = Yesterday,Current Week. In this two types of data at a time we can select only once and i want to does not reflect the values in second pivot table chart.
Please send me details.
Anand
I don't understand what you want.
Can you post an example?
I want to apply this type of condition like
=sum({$ <Year=, Month=, Day=, XXX=>} Sales)
To Inline type of load values like
CalendarChoices:
LOAD dual(CalendarChoice, CalendarChoiceNum) as CalendarSelection
INLINE [
CalendarChoice, CalendarChoiceNum
Yesterday, 1
Current Week, 2
];
Here we have selections like "Yesterday", "Current Week".
The code you suggested
=sum({$ <Year=, Month=, Day=, XXX=>} Sales)
It is works for the Year, Month, day etc. But i want to aply for "Yesterday", "Current Week" but it is single object or in single CalendarSelection values so please suggest me.
Isn't it an option to detacht the second pivot table?
Properties >> General >> check :Detached
Or does it need to change when you select something else?
Let's say you have the following data:
TblData:
LOAD * INLINE [
Date, User, Value
01/01/2011, Toto, 1
02/01/2011, Toto, 1
03/01/2011, Toto, 1
10/05/2011, Toto, 20
12/05/2011, Toto, 300
14/05/2011, Toto, 20
12/10/2011, Toto, 4
]
;
CalendarChoices:
LOAD dual(CalendarChoice, CalendarChoiceNum) as CalendarSelection
INLINE [
CalendarChoice, CalendarChoiceNum
All, 0
Today, 1
Current Week, 2
];
If you have a ListBox element for CalendarSelection with "always 1 selected value" checked, you can use the condition:
sum(if(
(CalendarSelection = 1 and Date = today()) or
(CalendarSelection = 2 and week(Date) = week(today())) or
CalendarSelection = 0
, Value))
Another solution is to add a flag in your load script on your data table to say for each field if it's "today", "this week", or watever you want.