SAP Analytics Cloud aggregation on drilldown

[AnnePetteroe]

Hi All:

I have an SAP SAC Story Time Series Line Chart that aggregates the stock price when I drill down to year.

The Story imports from a Model (as opposed to dataset)

How do I simply show the stock price for IBM, Apple, etc on last day of the year, and not the cumulative or aggreated stock price.

Thanks

AlphaRobb

[AnnePetteroe]

Hello Robert,

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will also help you when preparing questions for the community.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage your readers to respond.

Kind regards,
Anne

[N1kh1l]

alpharaffrobb

Depending on your model type, if you are using measures or Account member for price, set the exception aggregation to LAST with exception aggregation dimension as Time. Also if you have both Accounts and Measures in the model do check the structure priority of the model and set it to either Accounts or Measures depending on where you set the exception aggregation.

If using Account to store stock price

If using measure

Structure Priority if you both Measures and Account in the model

Hope this helps !!

Br.

Nikhil