Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all Please help me out top two values in current month comparing the same with previous month.
In June the top two profitted cuntries are Argentina and Japan
In May the top two profitted cuntries are America and Argentina
What i want is when i click on jun i want both june and may data to dispaly and the comparision should be between the selected month (jun) and top two values of it Argentina and Japan to Argentina and Japanin May
Where are you getting stuck ?
What's your output ?
Can you share your qvw or some sample data in excel, so that I can create a small app as per your data?
Try this in Second chart Expression
sum({<Year={$(=max(Year)-1)},Country=P({<Year={$(=max(Year))}>}Country)>}Sales)
My month format is 2016 may in the dashboard i want to write an expression on this format
you can write expression for 201605 and then convert it into 2016 may.
may be like this:
--> for previous month:
sum({$<MonthYear={"$(=date(AddMonths(max(MonthYear),-1),'YYYY MMM'))"}>}Value )
Hi varsha thank you so much its working fine great job and can i get a stacked chart in this
Hi i will try this
You're welcome!! I don't think so, give it a try.
Like this ?
or
two different charts:
Check this:
Stacked bar chart: