I'm trying to create a report containing sales and forecast (and index calculation based on these). My goal is a report with a product-hierarchy with the actual sales in one column - and the forecast in the nex column. My issue is that the forecast isn't made on the each individual product - but only on product Groups. My input data is illustrated below.
Does anyone have an idea on how I can merge these into one report? Since VA doesn't allow join 2 datasets directly in the report (as far as I know) then I think I need to join the tables on ProductCategory (obviously). But how can I show the FC only on the ProductCategory when drilling in the AC's in the report? When I join the below tables I get a FC of 40 on both Product 1+2+3 = 120. I could maybe just create a Measure as average - but the FC will still be 40 on each product. But 40 on top of the category.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.