Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I'm creating a chart based on the belwo data:
Region Country Rev
NAM US 10
NAM MEX 5
EMEA GB 6
EMEA GER 9
The issue is that when some body searches the data based on the country the chart is showing the Rev data for that country. For ex: if user searches for Country 'US' the chart shows Rev. number 10, whereas i alway want the chart to show data at Region Level, i.e it should show 15 for NAM.
How do i achieve this. My chart structure is
Region , Sum(Rev)
----------------------------
Thanks
P
HI
Try like this
=Sum({<Country=>} Rev)
it exclude the country selection