Wossen Kebede Posted June 16, 2022 Share Posted June 16, 2022 Hello, I have 4 columns that shows for each quarter of the year with the name of employee and company. I was trying to create a Cross table with the result as shown below: There is a filters for the year and quarters.My question is how can I calculate to get 0, whenever there is a NULL or BLANK in one or more rows of the Quarter's, the grand total is ZERO otherwise to add all based on selected quarter and year from the filter. Employee Company Q1 Q2 Q3 Q4 Grand total Joe AA 12 12 12 12 48 Dan BB 10 - - 15 0 Sarah CC 20 10 25 30 85 Can any body help me on this Thanks W Link to comment Share on other sites More sharing options...
Kevin Flynn Posted June 17, 2022 Share Posted June 17, 2022 In the value axis, put SN(Sum(Value),0) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now