How to find first n months profit/sales for a given year

0 votes
How to find first n months profit/sales for a given year?
Mar 8 in Tableau by sindhu
11 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Hi Sindhu,

You can use Calculated field to group those under first n months and then display using filter or color shelf.

1. First create a calculated field, 

2. Add year in the filter shelf to view only that years details.

 

3.Create N value as a parameter.

4. Now enter N value and add the created calculated field in color shelf to view details. (below shown for N = 1, 3)

Hope this helps you.

answered Mar 8 by CHERUKURI
• 13,940 points

Related Questions In Tableau

0 votes
1 answer

How to change months for a calendar year

Hey, you can try this & Change ...READ MORE

answered Apr 20, 2018 in Tableau by QueenBee
• 1,810 points
12 views
0 votes
1 answer

How to create a bar graph for two fields with same value?

I believe you want to have something ...READ MORE

answered May 28, 2018 in Tableau by Atul
• 10,200 points
29 views
0 votes
1 answer
0 votes
1 answer

How to get past N months date from data source?

Hi, this is a one solution to your ...READ MORE

answered Mar 1 in Tableau by CHERUKURI
• 13,940 points
48 views
0 votes
1 answer

How to get only the last n months action of all my records?

Hi Nithin, You can use Calculated field to ...READ MORE

answered Mar 8 in Tableau by CHERUKURI
• 13,940 points
31 views
0 votes
1 answer

How to compare sales of today with previous year?

Create a calculative field as, IF YEAR(TODAY())=YEAR([DATE_FIELD]+1 AND ...READ MORE

answered Apr 5 in Tableau by CHERUKURI
• 13,940 points
27 views
0 votes
1 answer

Need to take window average of last 3 months for my sales

Hi Ayushi, Create a calculated field to calculate ...READ MORE

answered Apr 22 in Tableau by CHERUKURI
• 13,940 points
16 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
946 views
0 votes
1 answer

How to calculate work done for a given date or period of time?

Hi, Follow these steps: As per you question since ...READ MORE

answered Apr 1 in Tableau by CHERUKURI
• 13,940 points
10 views
0 votes
1 answer

How to show outliers for a given set of points.

Hi Anshuli, Follow below steps: 1. Create a line ...READ MORE

answered Apr 17 in Tableau by CHERUKURI
• 13,940 points
32 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.