The cases when there is a deduplicated grand total or column sum are know. Generally it's as follows:   Deduplicated grand total  - when you bring in an entire dimension - when you use the filter on a dimension   Column sum - when you bring in individual dimension items or mix dimension items - when...

Hi @SatishKuumar, I'm not sure if you meant to include a screenshot with your description. But generally, what you're seeing is a deduplicated total. When you put a dimension in a freeform table, Adobe will give you the amount for each row, but then for the grand total at the top it will count what ...

If I'm understanding your question correctly, you want to know what percent of the add to carts came from each product? If so, you can do this using the column sum function in a calculated metric. The column sum is a function that adds up all of the values for a particular column - so it will add al...

Have you wished you had a guide for how to use advanced functions in your calculated metrics? Check out the link at the bottom of this post to see a new guide that I’ve written to help you understand the various functions available.

There was actually another question recently that was similar to this. There's actually two different ways you can do this, depending on how you want to lay everything out.   Method 1: You can use the cumulative average function. In my example I've used conversion rate as my metric. What you do to b...

That's one of the difficult things of the column sum is that it sums up the values in every row, where as freeform table totals normally have a deduplicated value. So the column sum is going to slightly overcount your unique visitors (and depending on how long of a time period you're using, it might...

This is another great way to do it. The one thing I'll call out with this method, is that if you want to use a time period other than the current one, you need to make sure to select "make date range components relative to panel calendar." So for example, if you're trying to do the last 7 days from ...

This would probably be a great use for the cumulative average function in a calculated metric. If you go into the calculated metric builder, at the bottom there is a section called "functions", in here there are a ton of different functions that you can use in your calculated metric. The cumulative ...

Adding on, found some documentation here   https://new.express.adobe.com/webpage/WFCyq7w8kijmB    Within the EOL notice for Reports & Analytics, there is one tiny mention about EOL for roll up report suites too (you have to scroll way down to find it).     

No, roll-up report suites are no longer a thing that exist. They went away a little while ago. Instead, Adobe recommends sending everything to a Global report suite and then splitting stuff up with VRS's and segments as needed. That's the reason there isn't any recent documentation anymore, because ...