Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a question about the display of the 100% stack column chart. Why would the entity "FW" shown in 100% but the x axis still have 150% ? In Alternative, I have choose another entity "HC" shown in 100% but don't have this issue.
Kindly attach for the screenshot and set analysis equation:
Equation: (Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"}>}Productnetamount)
+Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]={"PREPAID_****"}>}[sales_details.disc_amt])
-Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]={"PREPAID_****"}>}amt)
+Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"}>}cdisc_amt)
+Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]-={"PREPAID_****"}>}[sales_details.disc_amt])
+Sum({$-<[check_time.autoCalendar.Date]={'$(=date(max([check_time])))'},[sales_details.status]={"0"},[sales_details.item_code]={"*"}>}[sales_details.disc_amt]))
/(Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"}>}Productnetamount)
+Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]={"PREPAID_****"}>}[sales_details.disc_amt])
-Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]={"PREPAID_****"}>}amt)
+Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"}>}cdisc_amt)
+Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]-={"PREPAID_****"}>}[sales_details.disc_amt])
+Sum(total<Day>{$-<[check_time.autoCalendar.Date]={'$(=date(max([check_time])))'},[sales_details.status]={"0"},[sales_details.item_code]={"*"}>}[sales_details.disc_amt]))
Screenshot (HC)
fw