CategoryName Value greater than I(Issue with Totalvalue and Error message)
I have 2 queries regarding the below requirement. I have implemented the logic correctly and even the values are getting displayed correctly in the Bar chart.
The below Bar Chart displays you the Category Name Values greater than Company -'I'. There are 2 facts -EScore(not dependent on any dimension) and SEScore(dependent on SecCode). The below Bar chart displays the Category Name value greater than Company-'I' and it is showing correctly. I have come across 2 issues mentioned below.
Issue 1 : Whenever the values are not present, it should display custom error message " Score for I> Competition for all Category Names" in the bar chart.
For e.g. : When you click on Product Score, it should display the error message-"Score for I>Competition for all Category Names"
Issue 2 : When I click on Overall score- values are present but the total is not getting displayed in the chart(Title of the chart).
Kindly help me out in resolving the above 2 issues. Please find the attached QVW.