About vardhan_24

vardhan_24 · ‎03-11-2019

Thanks Vignesh for the detailed reply !

vardhan_24 · ‎03-08-2019

Hi All I have an audit module which has a list as dimension. The list contains multiple report names. The List is pivoted as rows and line items has 2 columns as Count and Total_amount. My need is to go to respective source module of the reports and fetch the total count of records in that report and sum(Total_amount) in that report. Please help suggest a right approach for the same. Thanks Yash

vardhan_24 · ‎03-07-2019

Hi You can use the hierarchical capability of SELECT() function to roll up any hierarchical attribute and get the desired value. In this case, you can roll up the total items sold at the top level.

vardhan_24 · ‎03-07-2019

Hi It's always good to store your transactional data in data hub (separate model) and then use action for imports. As a best practice one should always create a list for unique identifiers and then use that list as a dimension in the module. Thanks Yash

vardhan_24 · ‎03-07-2019

Hi Uma You can try using MOVINGSUM(). It should solve your issue. Thanks Yash

vardhan_24 · ‎03-07-2019

Hi Prabakaran You may use the ITEM() function to firstly extract the member of the list and then subsequently use NAME() to get the text value. Thanks Yash

Online Status	Offline
Date Last Visited	‎03-11-2019 02:34 AM

About vardhan_24

Re: Fetching Count and Sum Information different R...

Fetching Count and Sum Information different Repor...

Re: Get Value of Top Level

Re: Import raw data of transaction

Re: Calculations

Re: Data format change from List to Text

Re: Get Value of Top Level

Re: Get Value of Top Level

Re: Get Value of Top Level