Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Members,
i am trying to display sales using tree map: dimension as "Country" measure sum({<Month_Number= {">=94"},Fraud_Type=>}sales). but i have Fraud_type column which has 'internal, External' values by default tree map should show internal sales and if i select external button values should change.
can somebody help me.
there are couple of ways of approaching this. one way is:
cretae a variable like vFraudType. in your expression add FraudType={'$(vFraudType)'}. your buttons should set the variable to either Internal or External - whatever the values are.
your variable should have a default value
what you can do to get it working is create 1 variables within the edit mode.
say vUpdate with a default value like Internal. then in the set analysis you can call that variable and update the messure
sum({<Month_Number= {">=94"},Fraud_Type=$(vUpdate)>}sales)
then you need the buttons above to know that when you press one of then the vUpdate variable needs to get updated. for this, within the button you can go to actions and navigation and create a new action. set it up just like the screenshot below and you are done
if this helped and or was the answer you are looking for, give it a like and accept this as the answer.