Forum Discussion
Grouping data & sum negatives
Hi I have a table of Categoies (made up of Items), Weeks, Sites & a Value assigned to each. Category Item Week Site Value C1 I1 W1 S1 7 C1 I1 W1 S2 3 C1 I1 W2 S1 -...
Zubair_Muhammad
Community Champion
Community ChampionAnonymous
Could you share your file? Will try to help
Sorry for the late reply. Here is the sort of data I am using and a mocked up dashboard
Once the file is opened, the label should be displaying the sum of the boxes above. The one on the left is correct (sum of all the column), but the one on the right should sum all negative categories (-34061.3)
Thanks