# Ashwini Sayani

• Total activity 19
• Last activity
• Member since
• Following 0 users
• Followed by 0 users
• Subscriptions 8

## Activity overview

Latest activity by Ashwini Sayani
• Ashwini Sayani commented,

Thank you Ole! Much appreciated!

• Ashwini Sayani created a post,

### Sort by Multiple Columns

Hi, I have a table that looks like this - I want to multiple sort this:   Brand Item Description  Sales Acqua Di Parma COLONIA ESSENZA EDC 100ML 100 Acqua Di Parma ZAFFERANO EDP100ML 200 ...

• 2 followers
• Ashwini Sayani created a post,

### Multiple Dimensions - Calculation

Hi, what does the formula look like when I have two time dimensions on the columns? The user dimension below has only 2023, 2022 as members. The second dimension has Week 1, Week 2 etc.  I want to ...

• 2 followers
• 1 comment
• Ashwini Sayani commented,

Hi, improving on this example - how do I calculate the difference between prev month this year and prev month last year please?

• Ashwini Sayani commented,

Rank for top list with multiple dimensions – TARGIT Community - I found this helpful, but how do I only display top 3 in the first dimension with top 5 in the second dimension, what would be the vi...

• Ashwini Sayani commented,

Hi,  thank you this is very helpful! Can I ask what is the visibility agent formula to show ONLY top 3 Customers with their top 5 salespersons please?

• Ashwini Sayani created a post,

### Visibility agent for multiple dimensions

Hi,  There are two dimensions in the crosstab (country, item)  and one measure, sales.  I need to show the top 5 Airport Countries, with the top 10 Item Desc for each country. Is there a way of d...

• 2 followers
• Ashwini Sayani commented,

Yes, but I am only able to rearrange the dimensions that way (highlighted columns). I want to bring in the calculated columns at the end in between the first few columns.  For example, I want 'Cust...

• Ashwini Sayani created a post,

### Copy of existing Column (dimension)

Hi,  How can I create a new calculated column that would create an exact copy of the values in the first or second or third column here which are dimensions? Is there a syntax you could help me wit...

• 2 followers
• 1 comment