Hello.
We are trying to create a dashboard widget from our AR Overdue categories. We created a Pivot table widget which summarizes the outstanding AR balances by current, 1-30, 31-60, 61-90, and over 90. How do I turn the sum of these categories into a dashboard widget ?
Thanks,
Gwen
Best answer by BenjaminCrisman
HI
As long as they are based on the same data then they should be consistent, but it could require making a separate GI if the GI used for the original pivot isn’t already grouped.
The SUM() function or SUM Aggregate Function can only operate when a grouping is applied to the GI, but it might be quick if you can simply copy the GI and apply the necessary grouping, then make the widgets based off the needed summed fields.
+4HI
As long as they are based on the same data then they should be consistent, but it could require making a separate GI if the GI used for the original pivot isn’t already grouped.
The SUM() function or SUM Aggregate Function can only operate when a grouping is applied to the GI, but it might be quick if you can simply copy the GI and apply the necessary grouping, then make the widgets based off the needed summed fields.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.