
Contributor III
2020-03-07
11:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create dimension based on a measure
i would like to create a dimension that is a group of customers who used a particular promotion discount (Missed you coupon-$25).
i would then like to see the total sales from that group of customers in the last 12 months.
i created a dimension, =If(wildmatch(DISC_DESCR, 'Missed you coupon-$25'),Customer_Name).
this gives me the customer group that i want. but when i add a measure for last 12 months sales, it just shows the sales for that particular discount and not the total sales for that customer over the last 12 months.
hope i explained this correctly.
any advice would be most welcome.
John Doub
423 Views
0 Replies
